SQL count querry

Discussion created by markpelleymounter on Feb 23, 2016
Latest reply on Feb 23, 2016 by beverly

I am very new to (trying) to build ExecuteSQL statements and have already run into a stumbling block.


I have the following statement:



ExecuteSQL ( "SELECT COUNT (*)


FROM Clients

WHERE \"isactive\" = ?

AND \"Rep Name\" =? "

;   ""  ; "" ; "1" ; Clients::globaldisplayname )


It works, okay expect that the Rep Name field could have, for example "Tom Jones / Gary Smith" or just "Tom Jones"


If I am logged in as Tom Jones, I want the result to include all result that include my name.  As it is, the sql result only include exact matches.


Is there a quick way to have the results be all those that contain "Tom Jones" not just exact matches?