Re: escaped underscore

Mark Salter <[email protected]> Thu, 14 Sep 2006 07:36:09 +0100

Newsgroups	gmane.comp.db.mckoi
Message-ID	<[email protected]>

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/database/
To unsubscribe, send a message to [email protected]