extracting numeric data from column

[Guest]

Hello all. I have a column that has both numeric and alpha characters in it.
I want to pull out just the rows that contain only numeric data but cannot
seem to figure it out. Any help is apprecriated.

Thanks.

 

[Guest]

Using the IsNumeric as criteria, try

SELECT TableName.FieldName
FROM TableName
WHERE IsNumeric([FieldName])=True

 

[Pieter Wijnen]

try : Field: IsNumeric(YourField) WhereCondition: True
Pieter

 

[John Vinson]

Hello all. I have a column that has both numeric and alpha characters in it.
I want to pull out just the rows that contain only numeric data but cannot
seem to figure it out. Any help is apprecriated.

Thanks.

Create a Query based on the table, and put a calculated field in the
query:

ChooseThis: IsNumeric([fieldname])

Use a criterion of True on this field.

One caution: values such as "12E4" or "8123D0" will be considered
numeric even though they contain letters, since they are valid
scientific notation.

John W. Vinson[MVP]

 

[Jamie Collins]

I have a column that has both numeric and alpha characters in it.
I want to pull out just the rows that contain only numeric data

Using non-'ANSI-mode' wildcard characters:

my_column NOT LIKE '*[!0-9]*'

Jamie.

--