Finding Non-Numeric Values

[leadpro]

I need a query that looks for any occurance of a non-numeric value in a text field. Any ideas?

Thanks,

leadpro

 

[traingamer]

SELECT  txtfield
FROM table
WHERE ((Not (txtfield)=("IsNumeric")));

traingamer

 

[traingamer]

(Pay no attention to previous post)

traingamer

 

[PHV]

SELECT * FROM yourTable WHERE Not IsNumeric([textfield]);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[traingamer]

SELECT txtfield
FROM table
WHERE (((IsNumeric([txtfield]))=True));

traingamer

 

[traingamer]

At least it's friday:

SELECT txtfield
FROM table
WHERE (((IsNumeric([txtfield]))=[COLOR=red]False[/color]));

traingamer

 

[traingamer]

SELECT txtfield
FROM table
WHERE (((IsNumeric([txtfield]))=True));

traingamer

 

[traingamer]

Don't know where that last one came from -
PH has the answer I tried to type the first time.
:~/

traingamer