Function question

[Logan_(Guest)]

IIF(SUBSTR(NOTE,4,1)="H", SUBSTR(NOTE,1,3)+SPACE(1)+"H"+SPACE(1)+SUBSTR(NOTE,5,7),Ref2)____My statement worled until I discovered that substr(note,4,1) could equal other alpha characters. How can I modify the statement so it will return the value if subtr(note,4,1)>=A or substr(note,4,1)<=Z? I have tried nesting iif statements, and tried using the case statement, but cannot get it to work. (I am probably making this too hard.)____Thanks for your help.

[kfleming]

Try using ISALHPA.____The ISALPHA() function determines if the first character of an expression is any upper or lower case letter.____Kathleen__R&R Support