Select text values

GA_KEN · #1 (**permalink**) 03-14-03, 10:49

Hi all,

I have a column of data that has Account Numbers in it, it should contain all numric numbers.

Is there anyway to select all the rows that have text as the account number? i.e. if the account number is stored as say "abc" then I want to select it.

Thanks,

Ken

andrewst · #2 (**permalink**) 03-14-03, 11:10

Quote:

Originally posted by GA_KEN
Hi all,

I have a column of data that has Account Numbers in it, it should contain all numric numbers.

Is there anyway to select all the rows that have text as the account number? i.e. if the account number is stored as say "abc" then I want to select it.

Thanks,

Ken

What DBMS? I could tell you how to do it in Oracle, but I suspect you are on something else?

GA_KEN · #3 (**permalink**) 03-14-03, 11:11

I guess that would be important!

I'm using SQL2000

andrewst · #4 (**permalink**) 03-14-03, 11:37

Quote:

Originally posted by GA_KEN
I guess that would be important!

I'm using SQL2000

There is a SQL Server function called ISNUMERIC that looks like it fits the bill.

GA_KEN · #5 (**permalink**) 03-14-03, 12:02

Great!

Thanks for pointing me in the right direction! This works:

Code:

select *   from Accounttbl where ISNUMERIC([account number]) = 0

Thanks again!

Ken

Internet Services

Web Development

Digital Marketing

Consumer Tech