AW: RPG SQL (SQL Syntax?)

["HauserSSS" <Hauser@xxxxxxxxxxxxxxx>]

Hi,

duplicate the quote in J'MAJOR

WHERE ... UCASE(CASMN) like 'J''MAJOR, JOHN'

Birgitta

-----Ursprungliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von
jmajor@xxxxxxxxxxxxxxx
Gesendet: Dienstag, 15. November 2005 18:12
An: rpg400-l@xxxxxxxxxxxx
Betreff: RPG SQL (SQL Syntax?)


Thanks in advance!

I have a quick question and not sure what the syntax would be or if 
possible however I have a program that processes some sql for searching 
reasons for our system...  How would I perform a select on a character 
field with this type of value J'MAJOR, JOHN ...

I had the syntax setup as 

Select * From @FCCASE Where Ucase(PADR1) LIKE '9999 GROVE AVENUE%' OR 
Ucase(CFILE) = '83456324' OR Ucase(CASNM) LIKE 'J'MAJOR, JOHN%' OR SSNNO = 
999809999 OR SSNN2 = 999809999 

and it did not work which makes sense to me however not sure what the 
syntax would be for searching for a value of "J'MAJOR, JOHN%"

Thanks so much!
John