RE: Case Sensitivity in SQL Queries

2001-02-26 Thread Robert Hinojosa
try this in your order by Select firstname, lastname, UPPER(lastname) AS ordName FROM ... ORDER BY ordName -or- this might even work Select . ORDER BY UPPER(LastName) HTH, Robert Hinojosa Senior WebDeveloper [EMAIL PROTECTED] www.hencie.com 972-671-0011 ext.284 -Original Mes

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'm pulling a great big list of faculty names

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,