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 (*)
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?