Alphabetical sorting - SQL

[butchzn]

:)Hi can anyone pleez assist me, i am trying to sort my db results by first letter... ie a, b, c etc how would i go about this using SQL. i want to be able to select a letter and have it order my all results by that chosen letter. Thanks very very much Butch

[pbpb]

SELECT foo FROM bar ORDER BY SUBSTRING(foo,1,1)

[butchzn]

thanks very much pbpb this has proved to be very useful. thanks again