Re: Case Upper or Lower

2009-11-17 Thread Guillaume Rheault
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

Re: Case Upper or Lower

2009-11-17 Thread Chowdhury, Tauf
. 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

Re: Case Upper or Lower

2009-11-17 Thread Begosh, Kevin
] 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

Re: Case Upper or Lower

2009-11-17 Thread Chowdhury, Tauf
) [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

Re: Case Upper or Lower

2009-11-17 Thread Guillaume Rheault
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

Re: Case Upper or Lower

2009-11-17 Thread Begosh, Kevin
17, 2009 8: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