Determine in a query if a string has non numeric-characters
Posted on 2014-08-13
I have a table wich contains identification strings. I want to use a query to identify those which have any non-numeric characters in them. Examples of them are:
I tried a few things like
Expr1: IIf(IsError([CLIENTID]*1),99,1) and I also tried Expr1: IIf(IsError([CLIENTID]*1),True,False)
That gives me 1 or false respectively or #Error
I don't want the #Error , because I want to update another column with the result.