Query Problem

8 Sep 2006 1:44 PM

FARRUKH

We have a Invoice column which has a varchar datatype. the data is very
messed up. there is an int data(14786555), char data (letter) and also empty
field in a Invoice column. I am trying to run a query that only bring int
data and not bring empty, char and alpha numeric data.

anybody has any solutuon

thanks

Farrukh

8 Sep 2006 4:23 PM

Harsh Athalye

Select * from Table where IsNumeric(Col1) = 1

--
Regards,
Harsh Athalye
"Nothing is impossible"

Show quote

"FARRUKH" wrote:

> We have a Invoice column which has a varchar datatype. the data is very
> messed up. there is an int data(14786555), char data (letter) and also empty
> field in a Invoice column. I am trying to run a query that only bring int
> data and not bring empty, char and alpha numeric data.
>
> anybody has any solutuon
>
> thanks
>
> Farrukh

11 Sep 2006 7:38 AM

ML

This article explains more:
http://classicasp.aspfaq.com/general/what-is-wrong-with-isnumeric.html

ML

---
http://milambda.blogspot.com/