Webmaster Forum - View Single Post

jg_v7n · 05-03-2005, 06:28 AM

I have a column with text data in it, some of the data is alphabetical characters and some are numbers.

Is it possible to select all rows where this particular column consists of just numbers?

Something like:

Code:

SELECT * FROM table WHERE IS_NUMBER(column)

Thanks...

05-03-2005, 06:28 AM	#1 (permalink)
jg_v7n v7n Mentor Join Date: 08-26-04 Location: Rio de Janeiro Posts: 1,289 iTrader: 0 / 0% Latest Blog: None	select where column is number I have a column with text data in it, some of the data is alphabetical characters and some are numbers. Is it possible to select all rows where this particular column consists of just numbers? Something like: Code: SELECT * FROM table WHERE IS_NUMBER(column) Thanks...