Menu
Community /Pin to ProfileBookmark
@nbcrockettFeb 13.2008 — #Ok, I figured out that to get an apostrophe to work I have to use the code below. I still need to know how to get an ampersand to work. Any ideas?
Special Characters
I’ve got a select statement that can have an ampersand and apostrophy used in it. As you all know this wreaks havic on the select statement. My question is how do you get around this? If you know of other characters to be careful of please add them.
[CODE]
strSelect = “SELECT * FROM Table WHERE MyField LIKE ‘a&m'”
‘or
strSelect = “SELECT * FROM Table WHERE MyField LIKE ‘m’s'”
Sign in
to post a comment7 Comments(s) ↴
0
@nbcrockettFeb 13.2008 — #Ok, I figured out that to get an apostrophe to work I have to use the code below. I still need to know how to get an ampersand to work. Any ideas?[CODE]Replace(strMyString, "'", "''")[/CODE]