467,209 Members | 1,299 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

DB2 Table Editor Search Conditions

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
  • viewed: 1358
Share:
1 Reply
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.

Similar topics

9 posts views Thread by Ed_No_Spam_Please_Weber@Weber_Spam_Not_Enterprises | last post: by
7 posts views Thread by slitvinov@gmail.com | last post: by
21 posts views Thread by Johan Tibell | last post: by
10 posts views Thread by Greg Lovern | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.