8.2.5
I am having an issue with trying to use ‘LIKE’ so that I can match on a string with an underscore in it. What is the proper way to find the following string?
Table t1
Column c1
String I want to match on ‘abc_’
SELECT c1 FROM t1 WHERE c1 LIKE ‘%abc\_%’;
This gives me the following message:
WARNING: nonstandard use of escape in a string literal
LINE 1: ...ct c1 from t1 where c1 like '%abc\_%';
Remember I want an actual underscore.
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
