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
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
> 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,
3 matches
Mail list logo