Hi everyone
Before I forget, we are on V7r3

We have a file that contains some notes for each of our customers
These notes are displayed to users - however, the text field sometimes contains non-displayable characters that ends up with the program erroring out

This is due to the users cutting and pasting data from other mediums (word documents, e-mails, I.M.'s etc.)
My google search led me to this SQL query using TRANSLATE

SELECT rrn(a), a.CHNUM,
TRANSLATE(UPPER(a.CHTXT), ' ',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890!@#$%^&*()-=+/\{}[];:.,<>? "|')
, CHTXT
FROM nbjdta.csthistp a
WHERE
(TRANSLATE(UPPER(a.CHTXT), ' ',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890!@#$%^&*()-=+/\{}[];:.,<>? "|')
<> ' ')
order by rrn(a)

The example that I found did NOT include the characters " and |
I included them in the above SQL query
What is being displayed shows that the single quote is also included in the text field - but these are valid

Here is my question
How do I incorporate the single quote, to be used in STRSQL so that it becomes part of what to translate?

As always - all responses gratefully accepted



Alan Shore
E-mail : ASHORE@xxxxxxxx<mailto:ASHORE@xxxxxxxx>
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.