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