Re: check table for "special" characters.

Michael Borghoff wrote:
> I want to check 12 columns in a table for any characters others than A-Z & 0-9
>
> (e.g. a-z,?,#,...)
>
> (Oracle 8)
>
> How to do?
>
> Thank you.

In a loop check every character in every column for ASCII values NOT BETWEEN A-Z and 0-9. Keep in mind a-z is different from A-Z.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)