OK. I was trying to figure out how to stick an EVAL into it, but didn't get the 
formatting correct.
That works as well.

George

-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Thursday, May 16, 2013 11:05 AM
To: U2 Users List
Subject: Re: [U2] Selecting a special character in a SELECT (UV)

SELECT filename WITH EVAL "INDEX( @ID, CHAR(160), 1)" > "0"

On 5/16/2013 8:41 AM, George Gallen wrote:
> Ok.
>
> I'm trying to find all the ID's in a file that contain the character ^160
>
> I tried : SELECT filename WITH @ID LIKE "...^160..."
> But that didn't work.

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to