UPDATE:
SELECT Id, Name, Signature FROM User WHERE Signature = 'This is a test,
this is a another test,
this is a last test'
the above query returns the data only after I have split that in lines
Any explanation? I do not see any HTML code in the field
END UPDATE
I'm trying to write simple SOQL query that has comma in it.
SELECT Id, Name, Signature FROM User WHERE Signature = 'This is a test, this is a another test, this is a last test'
If i run the above SOQL I do not get any result and I even tried with LIKE
SELECT Id, Name, Signature FROM User WHERE Signature LIKE 'This is a test, this is a another test, this is a last test%'
Is there a way escape the comma
?
_
as a wildcard that matches a single character.This is a test, this is a another test, this is a last test
, or are your commas separating 3 separate possible signatures that you're trying to search for (e.g.Signature = 'This is a test' OR Signature = 'this is another test' OR Signature = 'this a last test'
)?\n
to escape those. The commas are just fine.\n
to escape