I am trying to trim an SQL query string. I have done the following which works good;
SQL = SQL.Replace(" ", "")
I also need to replace the character ' however My SQL statements require this, but any of my variables which pull info into the SQL string could possibly contain this character and therefore the following would mess up the query
'SupportPC', 'intel's pentium'
Intel's contains this character.
Is there a way around this?