List Info

Thread: escaped underscore




escaped underscore
user name
2006-09-14 06:36:09
Gonzalo Díaz wrote:
> I tried the backslash but it doesn't seem to work. I
> also tried a varied number of backslashes (2, 4, etc),
> to allow for Java backslash escaping, regular
> expressions, etc., to no avail.

Did you try leaving the escape off :-

    SELECT * FROM EMAILS_TABLE WHERE EMAIL LIKE '%_%'

Only a suggestion, I have not tried it, nor am I an expert.

Or do you have to escape it?

-- 
Mark


------------------------------------------------------------
---
Mckoi SQL Database mailing list  http://www.mckoi.com/d
atabase/
To unsubscribe, send a message to mckoidb-unsubscribemckoi.com

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )