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 ***

• Next in forum: Re: How to get table list from a db? Thanks!
• Prev in forum: Re: Query Question
• Thread view: Re: Performance-String searching

[Reply to this message]