General information
Category:
Coding, syntax & commands
You could try,
if at(" ", id) = 0
>CHRTRAN() is for characters but it sounds as though the field is a character type since it allows non-digit characters and spaces. The ten digits (0 - 9) are characters as much as letters and punctuation marks.
>
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only