pcsoft.us.windevCopyright 2026, PC SOFT30 Jul 2017 21:48:00 Z30 Jul 2017 20:05:00 ZHi all - I've got a piece of SQl I can't get working - sSQL is string = [ Select * FROM gpsdContact WHERE sFirstName LIKE '%1' AND sLastName LIKE '%2' AND bDeleted = 0 ] sSQL = StringBuild(sSQL,EDT_FirstName,EDT_LastName) At least this doesn't throw an error, but brings back an empty set. I want to find all names that start with whatever is in the edit fields. Any ideas?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61968-wb19-sql-question/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61968-wb19-sql-question-61978/read.awp30 Jul 2017 21:48:00 ZHi Joel, you coult be right about that.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61968-wb19-sql-question-61978/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61968-wb19-sql-question-61978/read.awpWB19 - SQl questionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61968-wb19-sql-question-61977/read.awp30 Jul 2017 20:47:00 ZHi Stefan - Actually, after looking at something on the Internet about SQL, I tried putting a % at the end and it worked fine…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61968-wb19-sql-question-61977/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61968-wb19-sql-question-61977/read.awpWB19 - SQl questionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61968-wb19-sql-question-61976/read.awp30 Jul 2017 20:26:00 ZHi Joel, the parameters should start with a % character, so try this: sSQL is string = [ Select * FROM gpsdContact WH…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61968-wb19-sql-question-61976/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61968-wb19-sql-question-61976/read.awpWB19 - SQl question