how do I sort this criteria in sql server?

i want to order by name as well as status in my order the status = A , T, C .. since the status is oder by it gives me the results as A, C, T ... my sql is,
SELECT A.EE_NAME,A.EE_STATUS
		 FROM EMPLOYEE_PERSONAL  A
		 INNER JOIN COMPANY_LIST B ON  A.BROKERID = B.BROKERID AND A.CLIENTID = B.CLIENTID
		 WHERE  A.BROKERID =1 AND B.BROKERID = 1 AND A.CLIENTID = 1
		 AND B.CLIENTID = 2
		 ORDER BY A.EE_STATUS, A.EE_NAME;

Open in new window

LVL 36
Loganathan NatarajanLAMP DeveloperAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
change
ORDER BY A.EE_STATUS

into

ORDER BY CASE A.EE_STATUS WHEN 'A' THEN 1 WHEN 'T' THEN 2 WHEN 'C' THEN 3 ELSE 99 END
0
 
Loganathan NatarajanLAMP DeveloperAuthor Commented:
perfect .. it works... many thanks ..,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.