Re: ISQL/4gl help
Use single quotes to quote the LIKE or MATCHES string:
select * from table where desc like '%"%';
select * from table where desc matches '*"*';
In 4GL you should be able to backquote the double quote character ala:
if desc[1,1] = "\\\\"" then ....
Art S. Kagel
----- Original Message -----
From: David Taylor <dtaylor@rpionline.com>
At: 5/ 1 17:41
> I'm trying to locate all records that contain a double-quotation mark in the
> description field....
> Here's an example of a row that I would want returned
> desc ROLL PIN 1/4 X 1 3/4",R05"
> I've tried using ISQL and using
> Select *
> From table
> where desc like "%\\\\"%" escape "\\\\">
> I've also tried
> Select *
> From table
> where desc matches "*"*">
> neither of these work.
>
> There is one other option i have... I am using a 4gl program to grab this
> description and I could change the description within the 4gl before the data
is
> output to the file it writes to. I'm not sure how to find a double-quote here
> either. The reason for doing this is because the description in the end
product
> will be enclosed with quotation marks and I can only have 1 set of quotes so
> this is acceptable:
> "ROLL PIN 1/4 X 1 3/4,R05"
> and this is not:
> "ROLL PIN 1/4 X 1 3/4",R05""
>
> Thanks in advance for any help.
>
> Oh yeah... running Informix 7.31 on AIX
>
> David
>
> ___________________________
> David Taylor
> Database Specialist
> Rapidparts Inc.
> 616.647.3108
> dtaylor@rpionline.com