Listing entries from a database alphabetically

[Dillenger]

Hi,

Is there anyway to list entries in a table alphabetically?

[sarahk]

check out some sql tutorials

the basic syntax is

select field1, field2
from mytable
where field1 = "Clowns"
order by field2 ASC

the ASC (A-Z, 0-9) is the default, for a descending (Z-A, 9-1) sort use DESC.