Good Afternoon Everyone,
I was wondering if I am running into a problem with ILIKE. Here is what happened:
When trying to execute this select statement:
SELECT * from elevlist WHERE fulldwgpath ILIKE '\\\\cad_svr\\someDirectory-name-thatis-long\\somefile.dwg'
0 rows are returned, but if I shorten it to:
SELECT * from elevlist WHERE fulldwgpath ='%somefile.dwg%'
my rows are returned. fulldwgpath is a varchar(250) datatype.
Any ideas?
thanks in advance
corey
