Filtering records by character type
-
- Posts: 1
- Joined: Tue Oct 10, 2017 12:44 pm
Filtering records by character type
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!
=> Filtering records by character type
[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.