Unanswered: Selective sort on table : query please
I need to understand and write a query for the following situation.
I have a table with the following fields
type : (home, work, roaming)
I wanted to write a query that displays the results in the following fashion.
First all the emails with type work are listed.
Secondly all the emails with type home are listed
Thirdly all the emails with type roaming are listed.
I wanted to know if I could write such a query.
Unfortunately, the type is a string instead of a number.