Like problem

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