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.
strSelect = “SELECT * FROM Table WHERE MyField LIKE ‘a&m'”
strSelect = “SELECT * FROM Table WHERE MyField LIKE ‘m’s'”
Help @nbcrockett spread the word by sharing this article on Twitter...Tweet This