Posted by Chandra on 08/03/05 17:03

Hi

Hope this can help you:

SELECT *
FROM <TABLE>
WHERE <COLUMN> NOT LIKE '%[^A-Z0-9]%'

this returns only those fields whose column have a valid char.

hope this answers your question

best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---------------------------------------

*** Sent via Developersdex http://www.developersdex.com ***

[Back to original message]