Filtering records by character type

[Tom_Blake_(Guest)]

I am trying to create a report which only displays records where the first 2 characters of a field are alpha.____If anyone has any ideas, I would be most grateful for some help,____Thanks!

[freitas]

[updated:LAST EDITED ON Oct-02-02 AT 11:53 AM (EST)]ISALPHA ____iif(isalpha(substr(text,1,1)),"YES","NO" )______isalpha will equal True or False. The statment above states to say "YES" if it is alpha and "NO" if it is not.____You would need to make another statement of substr(text,2,1) to check and see if that is alpha also. Then if both equal alpha, you can display the text.