finding alphanumeric characters in column

[bebil2]

Hi guys,

Im using Access

i got this problem:

I have a list of street numbers, eg 1, 4, 8, 33, 44, and also some that contain some alphanumeric characters: eg: 21A, 21B, 21C.

I need to find out how to determine if a string has an alphanumeric character or not. I have used the access help but it is very vague and also Ive googled. One answer I found was to write a module, but Im not sure if thats the best way.


Please help as Im really stuck.

thanks in advance.

 

[Smart]

You could incorporate the following code into your query
SELECT IIf(IsNumeric([field1]),"Yes","No") AS alphaornum
FROM Table1;
If the table contains the following street numbers
1,2,3a,4,4b
The above code will return
yes,yes,no,yes,no