Escape & symbol
852076May 3 2011 — edited May 4 2011Hi everyone!
I am trying to execute a query that looks for any entry in a field that STARTS with "&". When trying to do:
Name LIKE '&%', it promps me for the value of the biding variable. I have also tried:
Name LIKE ' &%'
Name LIKE '||"&"||%'
Name LIKE '&&%'
Name LIKE '\&%' ESCAPE '\'
But nothing seems to work. Could someone help me on this one?
Thank you!