Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

About ORDER BY...

Status
Not open for further replies.

iulian

Programmer
Dec 27, 2002
3
SE
Hi,
I am using ORDER BY to sort rows based on a column containing strange strings like ("?@@??$&##ADSDG").
Sample of the column:

ev_0516=# select * from temp order by sortare;
sortare
---------
???&&
?&&#
1?&&#
1?&&#
1?A
1?&#A
1M
1?M
2A
2M
?A
?&&#A
A^
AZ
?BA
BA?
BB
?MA
?ZA
(19 rows)

I need to obtain a real sort based on charcodes that will at least group toghether strings starting with ? or @.

Am I stupid or what ???
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top