SQL easy question

[sabavno]

Hi,

What is the right SQL syntax for the query

Select * from Table1 where Field1 is not numeric

I only know VBA function IsNumeric, but don't know SQL function.

Please help

Thanks

 

[EvilCabal]

I don't know if there is an SQL equivalent of this function but in Access queries you can do it like this :

Select * from Table1 where IsNumeric(Field1) = False

 

[BillPower]

SELECT Not IsNumeric([field1]) AS Expr1, *
FROM Table1;

 

[VicM]

sabavno:

I would suggest you create your query in query design mode and test it. If it works, just view the query's SQL. You should be able to copy and past the SQL string where you need it.

Vic