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 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
