By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 951 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

DB2 Table Editor Search Conditions

P: n/a
JC
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.

Mar 13 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 13 Mar 2006 13:41:01 -0800, "JC" <je********@earthlink.net> wrote:
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.


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
Mar 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.