Is there any built in functions in postgreSQL? let's say for instance there was an upper() function you could create a custom column within the criteria of a normal search action
example upper(column) = <@UPPER STR="@@user$value"> Ben Johansen - http://www.pcforge.com Authorized WiTango Reseller http://www.pcforge.com/WitangoGoodies.htm latest beta downloads @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jeffrey Bohmer Sent: Wednesday, October 16, 2002 7:00 PM To: Multiple recipients of list witango-talk Subject: Witango-Talk: Case insensitive search in search action Is there a way to create a case insensitive search in a search action instead of using a DirectDBMS action? I want the user input to match regardless of case, so that 'blue' would match 'blue' and 'Blue' and 'BLUE', etc. I'm using PostgreSQL, which is case sensitive and cannot really be made case insensitive. I have a bunch of search actions converted from FMP, which is case insensitive, and would like to avoid re-creating them as DirectDBMS actions. Witango 5, iODBC, Mac OS X. TIA, - Jeff -- Jeff Bohmer VisionLink, Inc. _________________________________ 303.402.0170 www.visionlink.org _________________________________ People. Tools. Change. Community. ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
