Re: SQL*forms 2.3 UPPER/lower Case problem

In article <1993Mar25.031030.29712_at_asl.dl.nec.com> cdickson_at_tssc.wlg.nec.co.jp (Chris Dickson) writes:

   I am currently maintaining some forms in SQL*forms 2.3, an have    struck a problem
   with the use of the UPPER() and LOWER() SQL function - used in a    WHERE/ORDER BY
   clause for a Query. The Data being queried is stored in a mixture on CASES    eg.

         STC/ST
         STC/STLC
         stc/stlc (Regression)

   Users are having some diffuctility quering data because of the    mixed case - My question is do the UPPER() and LOWER() functions    work in the WHERE/ORDER BY clause - if they dont has anybody got    any ideas on how to do it

sure:
WHERE UPPER(column) <operator> 'STC'
ORDER BY UPPER(column)

--
This opinion will self destruct in 5 seconds.
danny vanderryn--dvanderr_at_oracle.com   || Take my advice ---
{uunet,hplabs,apple}!oracle!dvanderr   || *I'm* certainly not using it.
(415) 506-3142                         ||