markpelleymounter

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?

Outcomes