Re: SQL Case Sensitive selection

   If you want case-sensitive just use what the user keys to search,
   otherwise use
   UPPER(database_table_column_name)    =    UPPER(whatever user keyed)   
   --OR--
   LOWER(database_table_column_name)   =    LOWER(whatever user keyed)

   hth

   Marco Velazquez wrote:

 I'm trying to provide users with the ability to toogle between making their
 search case-sensitive or not by using the following:

   * Case-sensitive selection
  c                   if        pCase = Yes
  C*/EXEC SQL
  C*+   SET OPTION SRTSEQ = *LANGIDUNQ
  C*/END-EXEC
  c                   else
  C*/EXEC SQL
  C*+   SET OPTION SRTSEQ = *LANGIDSHR
  C*/END-EXEC
  c                   endif

 However this is not having an effect on the result set...   Does anybody has
 any ideas?

 Thanks,

 Marco.