Querying string with apostrophe in SOQL

I need to query string with apostrophe in it.

SELECT NAME FROM ACCOUNT WHERE NAME = 'TEST'ING'

Right now, i get a error message saying MALFORMED QUERY. Can someone help me on this?

Message Edited by SArun on 11-13-2009 04:56 AM

Nick1746323
The escape for apostrophe is just \'

i.e.

SELECT name FROM Account WHERE Name = 'TEST\'ING'

Need an account? Sign Up

Have an account? Sign In