ORDER BY Upper(lname) ASC
2. Redo your database with a proper many to many join. Otherwise, you're in
for a world of hurt.
----- Original Message -----
From: "Daniel Kessler"
> I have two questions.
>
> 1 - I have a list that I sort by last name (ORDER BY lname ASC). I
> don't have control over the data entry and noticed today that A-Z
> (uppercase) is before a-z (lowercase). Is there a way to get them to
> sort together (Aneka, botha,Sebrook, etc.)?
>
> 2 - I have a DEPARTMENT column which lists multiple departments. As a
> temporary kludge, I list all the departments in one column and
> separate them with a pipe "|". For example, "Kinesiology|Office of
> the Dean" I need to be able to do a query for each department
> separately, so that I can list all the "Office of the Dean" people,
> which is it's own page. If I enter just "Office of the Dean" it
> works, but if it's "Kinesiology|Office of the Dean", it doesn't show
> up. Here's the query:
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
