Peter Boughton wrote: > You didn't specify which database engine you're using? > > For PostgreSQL: > WHERE field_name ~ '^[0-9]+$' > > For Oracle: > WHERE REGEXP_LIKE(field_name, '^[0-9]+$'); > > For MySQL: > WHERE field_name REGEXP '^[0-9]+$' > > For MS SQL Server: > WHERE (NOT field_name LIKE '%[^0-9]%') AND field_name <> '' > > > (And if you're not using one of those, lookup how to do regular expressions > and adapt as appropriate.) I am back on this project today. I am dealing with an Oracle 7 DBMS here. It looks like the regex option does not work for this version of Oracle. As best as I can Google, regex doesn't come into Oracle until version 10.
Any other ideas folks? Ian Skinner ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3047 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
