Re: SQL statement to select numeric data?

From: "Bashar Chalabi" <bashar@ctl.com> > >In a stored procedure, assign the value to a numeric variable and trap the >error. Given the sample data below, I don't think this will work either. >joel_anderson@prosolution.com wrote in message > >I am working with data that is not normalized. One column has numeric > >and non-numeric data as in the following example: > > > > 20,234.17 > > WAIVER > > 10.99 > > CANCEL > > > >Is there a way to select only the rows with numeric data? I was hoping > >to use something like IS NUMERIC or IS NUMBER, but couldn't find > >anything that will work. If there is not an SQL statement that will > >work, does anyone have sample stored procedure code that will work? I would simply have a select with a where clause like: WHERE column MATCHES "*[0-9]*" because I think that the formatting commas in the data will cause hassles. 0.02c -- Bye now, Obnoxio "The one with the smartest marketing department wins" ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com