How to test if a value is a string 1

[Cloonalt]

I had a function to test in a query if a value is a string and can't find it now.

Any help appreciated.

Thanks.

 

[PHV]

You wanted this ?
SELECT ...
FROM ...
WHERE yourTextField = [!]'[/!]value[!]'[/!]

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

 

[Cloonalt]

In the query grid NewValue: IIf(is str([Old Value],true,false)

except that "is str" is not correct.

Thanks.

 

[PHV]

I know the IsNumeric function but no IsStr ...

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

 

[Cloonalt]

That works too. Thanks!