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 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 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 the query
that I don't want it to alphabetize sensitive to case? How about when I
output it? What I just read regarding the groupcasesensitive attribute of
cfoutput is that you set it to "no", and it will preserve the case
insensitivity of an already case-insensitive query. I just wish I *had* a
case-insensitive query to preserve!
Willy Ray
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
