SQL Order By

[dc1pop]

Im trying to list items on a page by letter, But i need to know what statement to use so it only selects words beginging with the spcificed letter. For example i will have a page with a heading of that letter and then the results:

Heading A

A Results


Only help would be great!

Thanks.

 

[Jim_]

SELECT * FROM table ORDER BY name LIKE 'a%';

This will return only results where name begins with a.

 

[moondog]

order by would alphabetize a column either ascending or descending. If you want to pick all records in a DB where a field begins with "A", then your SQL would look like this:

SELECT * FROM <TABLE> WHERE <FIELD> LIKE 'A%' order by <FIELD> ASC

If you want them in reverse alphabetical order (e.g Z to A), it would look like this:

SELECT * FROM <TABLE> WHERE <FIELD> LIKE 'A%' order by <FIELD> DESC

Of course, if you have both capital and lower case A's in the DB, you might need to do something like this:

SELECT * FROM <TABLE> WHERE <FIELD> LIKE 'A%' or <FIELD> like 'a%' order by <FIELD> ASC

Cheers!

-Bob

 

[dc1pop]

Thanks works well