Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 sorting alphabetically case sensitively

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-05-15 : 07:21:58
ashwini writes "i have 300 entries in database i want to sort it aplhabetically and also group like cases i.e
as
aww
Apple
Aiiu
b
buj
Buuu
so on .... till z
usual compariison takes ascii value using orderby clause how do i achieve this"

SamC
White Water Yakist

3467 Posts

Posted - 2003-05-15 : 07:38:09
This problem has been solved in the forums several times. To look for the answer, try the Forum Search link at the top of this page and enter case sensitive order as the criteria.

There are several links. Here's one:

[url]http://sqlteam.com/Forums/topic.asp?TOPIC_ID=15536[/url]

Sam

Go to Top of Page
   

- Advertisement -