Length and alpha recognition 2

[Cordeiro82]

Hello all...
I have a table with a column called Item Number and I need to find all item numbers that have a length of 14 characters with NO alphabets. Is there any way I can do this without having to resort to VB?

Thanks,

Kevin

 

[Golom]

Not really. You can

Where Len([Item Number]) = 14 AND IsNumeric([Item Number])

But that won't catch things that contain non-alphabetic characters like ,.$%&*@ ... etc.


[small]On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question. (Charles Babbage)[/small]

 

[PHV]

WHERE Len([Item Number]) = 14 AND [Item Number] NOT Like '*[A-Z]*'

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

 

[Cordeiro82]

Thanks a lot guys, really appreciate the help.