View Single Post
  #2 (permalink)  
Old 28-Jul-2006, 08:36 AM
Nikos Yannacopoulos's Avatar Nikos Yannacopoulos
Guest
 
Posts: n/a
   
   
Re: Filter based on first character of field

One way is to use a criterion like:

(>="A*" And <="Z*") Or (>="a*" And <="z*")
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13350-filter-based-on-first-character-field.html

if you want both upper and lower case, or just the first part if you
only want upper case.

HTH,
Nikos
Reply With Quote
 
Page generated in 0.44507 seconds with 25 queries