You can also UPPER (or LOWER for that matter) before the search/query is executed with an active link firing on Search
Guillaume -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Chowdhury, Tauf Sent: Tue 11/17/09 10:19 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower Yeah, it's a simple UPPER function on return type of thing. We did that also so the user can type whatever they want in the lookup field. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Begosh, Kevin Sent: Tuesday, November 17, 2009 10:14 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** That is what we did, everything in the DB is upper case. But from the user stance it is seamless. Most of the data that the user interacts with we turned to all caps when it was being passed to the DB. Also when the employee was searching, we turned that to all caps so it would find a match in the DB. It was some extra workflow but it makes it a lot less confusing on the customer. Kevin Begosh, RSP Remedy Development ACE-IT IS&GS Defense 301-791-3540 Phone 240-291-2467 Cell kevin.beg...@lmco.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Tuesday, November 17, 2009 8:11 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** We have an Oracle DB and thus, we are case sensitive. Because of this, we've chosen to make any character fields that a user will be doing a lookup on (last name, first name, product name, host name) Upper case. We found that upper case was easier to read as sometimes an "l" (lower case L) can be interpreted as an uppercase "I" (as in India) or the number 1. For Drop down menu's like CTI stuff, we just left it Case insensitive since users will be mostly selecting from a drop down. In hindsight, everything in CAPS would have been better. HTH Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Tuesday, November 17, 2009 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: Case Upper or Lower ** If your database is case insensitive, I suggest host name be in lower case. Tier 1, Tier 2 and Tier 3 can also also be in lower case with the first letter capitalized, except for acronyms that should be in upper case Guillaume -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Kathy Morris Sent: Fri 11/06/09 12:46 PM To: arslist@ARSLIST.ORG Subject: Case Upper or Lower Hello, We are trying to make an internal decision to design the Tier 1, Tier 2, Tier 3 and host name fields. We are torn between making the data in those fields all upper case, or all lower case. Does anyone have any opinions as to which way is better. We want to make sure the data is easy on the eyes to read, and yet visible. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ________________________________ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ********************************************************************** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"