RE: select * from x where data=numeric
Chris,
Try this:
select *
from table
where substr(trim(moredata),4,3) MATCHES "[0-9][0-9][0-9]";
-Dave
David Buchholz
Sr DBA
Vital Processing Services
david.buchholz@vitalps.com
-----Original Message-----
From: owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org]On Behalf Of christrier
Sent: Friday, June 10, 2005 01:16
To: informix-list@iiug.org
Subject: Re: select * from x where data=numeric
well i found a solution with:
select * from table where substr(trim(moredata),4,3) NOT MATCHES'*[a-zA-Z+-*]*';
although I don't like the negativ test
if there is the possibility to check if a substr is a numeric let me
know :-)
greetings
chris
sending to informix-list