Page 1 of 1
Filtering records by character type
Posted: Wed Oct 02, 2002 6:59 am
by 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!
=> Filtering records by character type
Posted: Wed Oct 02, 2002 11:51 am
by 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.