finding asci value of non printable character

There us some sort of unprintable character at the end of several of my input recs in a varchar (30) description column. It is causing the usual mayhem by being treated as a delimeter and splitting the record. They are not the usual ascii values (I think 10 and 14) for newline and tab.  Can I dump this column to get the value.  From there I can either translate it or replace it.
tminelginAsked:
Who is Participating?
 
cyberkiwiConnect With a Mentor Commented:
You can combine ascii with right, e.g.

select ascii(substr(somecol, -1,1)) from tbl
select ascii(substr(somecol, -2,1)) from tbl
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
There is a dump sql function.  Check out:
psoug.org/reference/convert_func.htm
0
 
cyberkiwiCommented:
You can use the ASCII(str) function but it works on the first char in str
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.