Sorting issue

[Bari]

hello

I have list report and have a column Category which has "New Store" and "Old Store”. This report is mainly developed through

Sql Query. The Problem is when i drag Category column it comes as New Store and Old Store where as the requirement is that it

Old stores should come first. What i did is I dragged a data item and wrote expression if([sql][Category]= 'Same Store') then (1) else (2)

and then cut the column from report page and sorted category as descending, it did the trick and met the requirement. My question is when i am sorting as ascending it is same old thing where as ascending should have worked. I am confused, what is going on here. Could gurus please explain. Thanks.

[VHF]

What database platform and reporting tool are you using?