JungleMonkey
Programmer
I am using Access 97 on the backend, VB6.0 and ADO. I have a table with this entry:
W. S. M. Z.--103.1 FM
Using a simple query to find this string, "Select * From TableA where thisField = 'W. S. M. Z.--103.1 FM', I recieve no records in my recordset.
When I delete the two hyphens and the 103.1 FM, it the sql string finds the record.
My question is that when I have two hypens in a field, do I use a delimiter
W. S. M. Z.--103.1 FM
Using a simple query to find this string, "Select * From TableA where thisField = 'W. S. M. Z.--103.1 FM', I recieve no records in my recordset.
When I delete the two hyphens and the 103.1 FM, it the sql string finds the record.
My question is that when I have two hypens in a field, do I use a delimiter