Murray Brown
asked on
Access SQL- SELECT WHERE text exists in the string
Hi. I want to convert the following SQL statement so that if "PARENT" exists [Apllicable to] it selects that record. Do I use the Instr function or is there a better function? In other words if
[Applicable to] contained "PARENT,STAFF" then it would select that records
sSQL= "SELECT * FROM [Table1] WHERE [Applicable to] = ' PARENT'"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER