Home » SQL & PL/SQL » SQL & PL/SQL » non-alpha,non-numeric characters
non-alpha,non-numeric characters [message #365448] Tue, 02 June 1998 17:33 Go to next message
Carol Duncan
Messages: 1
Registered: June 1998
Junior Member
What's the best way to select columns that contain characters other than A-Z or 0-9? I have some tables that were loaded from data that was originally EBCDIC. Some of the data contain characters that I can't identify (but I know they're not Nulls, Blanks, or Tabs).
Re: non-alpha,non-numeric characters [message #365578 is a reply to message #365448] Wed, 02 December 1998 08:52 Go to previous message
Messages: 4
Registered: November 1998
Junior Member
Try selecting the data as ascii charaters.

Select ascii(column_name) ....
Previous Topic: Reference Cursor Variable for Dynamic Tables?
Next Topic: Day, Month, and Year values from PL/SQL8
Goto Forum:

Current Time: Wed May 29 09:16:56 CDT 2024