I'd like to build a form which does a case insensitive wild card search
on a character field. For example, the resulting SQL might be 'select
last_name from student where ucase(last_name) like '%SMITH%', where the
"SMITH" is a search string pulled from the form. That is, I'd like the
user to just enter 'Smith' and then have DB2 Table Editor perform the
case insensitive search. Is this possible? Thanks.

On 13 Mar 2006 13:41:01 -0800, "JC" <jenniecobb@earthlink.net> wrote:
[color=blue]
>I'd like to build a form which does a case insensitive wild card search
>on a character field. For example, the resulting SQL might be 'select
>last_name from student where ucase(last_name) like '%SMITH%', where the
>"SMITH" is a search string pulled from the form. That is, I'd like the
>user to just enter 'Smith' and then have DB2 Table Editor perform the
>case insensitive search. Is this possible? Thanks.[/color]

This should be possible to do by creating a refer-back condition that
references the control that the user enters the name in. The
CaseOrPassword setting for this control can be set to UpperCase which
will allow a case insensitive search if the UCASE function is used on
the column as in your example. Hope this helps.

Mark