Is the CHRTRAN() for character and not numbers? I am trying to use this for to check for an ID field that must have every number (and/or with a possibly characters) and must have no space in between. While testing, I could type all numbers, sometimes it works, sometimes not, and if I mix numbers with characters, sometimes it works, sometimes not, all that? This is what I have in my code:
LEN(CHRTRAN(id," ",""))=8
Chuck
Today is tomorrow's yesterday.