RE: SQL and the single quote (')

["Murphy, Guy" <murphy@xxxxxxxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]

        I badly represented the problem in my first note.  We are trying to
select on a name with an apostrophe in it.
Doubling the apostrophe was the key though.  This code finally worked:

        PGM
        runsql ('-
        SELECT * FROM LIBRARY/FILE WHERE LNAME = +
        ''D''''Angelo''')
        ENDPGM


Guy Murphy
murphyfa@uiuc.edu
UDIS at the University of Illinois
217-333-8670
http://www.heisercoaching.com


-----Original Message-----
From: Vernon Hamberg [mailto:vhamberg@attbi.com]

Bite the bullet and double up the apostrophe - do some kind of SCAN on it
and insert an apostrophe wherever found