RE: Case Sensitivity in SQL Queries

2001-02-26 Thread Robert Hinojosa
Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 3:29 PM To: CF-Talk Subject: Case Sensitivity in SQL Queries I'm pulling a great big list of faculty names from our mammoth admisitrative database. The query is alphabetizing Lowercase names after Uppe

Re: Case Sensitivity in SQL Queries

2001-02-26 Thread Howie Hamlin
Try something like: Order by ucase(lastname) Regards, Howie - Original Message - From: "Willy Ray" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 26, 2001 4:28 PM Subject: Case Sensitivity in SQL Queries > > I'

Re: Case Sensitivity in SQL Queries

2001-02-26 Thread Joseph Thompson
> I'm pulling a great big list of faculty names from our mammoth admisitrative database I just wish I *had* a case-insensitive query to preserve! Have you tried the "scalar SQL function UCase? http://cfhub.com/SQL/scalars/ucase.cfm It should "force" the results to all upper case... of course,

Case Sensitivity in SQL Queries

2001-02-26 Thread Willy Ray
I'm pulling a great big list of faculty names from our mammoth admisitrative database. The query is alphabetizing Lowercase names after Uppercase names, so I've got a guy with a last name of van Oosterhout, and that's coming in after a guy named Zimmer. Is there some way for me to specify to