Re: NewEra Case-Insensitive Search

mike, try using the upshift and downshift functions in the queryrowcheck event if you're using a supertable and all data in the database is stored in upper/lower case. you can also try using the upper and lower sql functions. (i think that's what they are). use these to convert both values to the same case. it can be done. -jason > > I have a data entry field for free form text, allowing the > user to enter both upper and lower case text. Is there a > way to do a case-insensitive search on this field? > > i.e.: query "City" and find occurrences of "CITY". > > Thanks for your help. > > Michael Campbell > City of Englewood, CO > mcampbell@ci.englewood.co.us