Okay, I copy this from salesforce link here.
Sequence | Meaning |
---|---|
\n or \N | New line |
\r or \R | Carriage return |
\t or \T | Tab |
\b or \B | Bell |
\f or \F | Form feed |
\" | One double-quote character |
\' | One single-quote character |
\\ | Backslash |
LIKE expression only: \_ | Matches a single underscore character ( _ ) |
LIKE expression only:\% | Matches a single percent sign character ( % ) |
This is how I run query using escape for single in Force Explorer.
select Id,Name from Country where Name in('COTE D\'IVOIRE','CURACAO','KAZAKHSTAN', 'LAO PEOPLE\'S DEMOCRATIC REPUBLIC','LIBYAN ARAB JAMAHIRIYA','MACAO') order by Name
No comments:
Post a Comment