RE: SQL and the single quote (')

["Weatherly, Howard" <Howard.Weatherly@xxxxxxxxxxxx>]

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 ]
The select could be coded using a LIKE predicate, SELECT name from table
where name like '%Angelo' however you may get more rows than you want.

-----Original Message-----
From: Murphy, Guy [mailto:murphy@uif.uillinois.edu]
Sent: Tuesday, June 25, 2002 6:16 PM
To: 'midrange-l@midrange.com'
Subject: SQL and the single quote (')


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 ]
        One of our programmers is trying to read a name field from a file
with an SQL statement.  The name is D'Angelo.  The single quote as I
understand it is causing the program to halt because the single quote is the
string delimiter.  In the SQL reference manual it says that the string
delimiter can be changed to double quotes in Cobol but that the delimiter is
fixed in our high level languages.  We don't have Cobol. Is there a work
around for this in RPG or Java?


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

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.