Re: finding rows matching pattern

From: andrewst <member14183_at_dbforums.com>
Date: Tue, 26 Aug 2003 06:07:34 -0400
Message-ID: <3284900.1061892454@dbforums.com>

Originally posted by Ronald Fischer

> Say, I have a column C of type varchar. Is it possible using
> SQL to find

> all rows, where C contains only characters from a specific set - for

> example, only digits? That is, a row where C contains '52063'
> should be

> selected, but a row where C contains '81BF42' should not be selected.

> Ronald

WHERE TRANSLATE(c,'x0123456789','x') IS NULL

--
Posted via http://dbforums.com

Received on Tue Aug 26 2003 - 05:07:34 CDT