Identify alpha characters in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm currently working on an address resolution project and I need to be able
to identify alpha characters in a street number field.

Example: Apt 20

Ideally I'm looking to create an IIF statement that I can use to create a
Flag column and then filter. I know I can use a generic Like criteria, but
it is just not scalable with the amount of day to day activity that occurs.

Thanks,
 
Thanks Douglas,

I think I also had some success with IsNumeric([Field]) as well. I'll
definitely give that option a spin as well.
--
Chris Unger
Analyst - Tyler, TX


Douglas J. Steele said:
See whether Val([TheField]) = [TheField]
Click to expand...
 
Back
Top