{exp:query sql="SELECT cat_name, cat_id FROM exp_categories WHERE parent_id = ‘2’"}
<li>{cat_name}<br>
{/exp:query}

I’m using this code to only show category items that only belong to a specific parent, but it doesn’t list the categories alphabetically, instead it does it by cat_id.  Is there anyway to sort it alphabetically?

SQL:  SELECT cat_name, cat_id FROM exp_categories WHERE parent_id = ‘2’ ORDER BY cat_name;