[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Writing a single quote in a string


Create a string that contains the ASCII value of the single quote and
concatenate that to the rest of your string.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Griffith, Peggy
Sent: Tuesday, February 21, 2006 9:11 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Writing a single quote in a string

Hi - my SQR is writing a text file and I need to include a single quote
as part of a string; does anyone know how to do that?  

 

Example:

let xxx = ''3207368'10001 'HRAF'

(after the first single quote there is supposed to be a single quote,
and then within the string there are 2 other single quotes as well as a
space).

 

I have been told to try using the single quote within single quotes
which does not work, also told to try 4 single quotes before the string
but that does not work.

 

Peggy Griffith

Business Systems Analyst

Sappi Fine Paper North America

179 John Roberts Road

South Portland, Maine 04016

Tel: 207.854.7466

 

 


This message may contain information which is private, privileged or
confidential and is intended solely for the use of the individual or
entity named in the message. If you are not the intended recipient of
this message, please notify the sender thereof and destroy / delete the
message. Neither the sender nor Sappi Limited (including its
subsidiaries and associated companies) shall incur any liability
resulting directly or indirectly from accessing any of the attached
files which may contain a virus or the like.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users