C
Craig Ferrier
I am trying to do a select query with criteria to find certain characters.
These characters include * # ?.
I want to find accounts with 123#456, or 123*456, or 123?456
I need to write this into an sql statement
Dim strSQL as string
strSQL = "SELECT Table.Field FROM Table WHERE Table.Field Like ....
How can i do this?
Also Can i put a Chr( ) reference inside the query.
These characters include * # ?.
I want to find accounts with 123#456, or 123*456, or 123?456
I need to write this into an sql statement
Dim strSQL as string
strSQL = "SELECT Table.Field FROM Table WHERE Table.Field Like ....
How can i do this?
Also Can i put a Chr( ) reference inside the query.