[RESOLVED] Ordering a varchar column that has numbers and letters

[OniLink]

Hi,

I have a varchar column that contains 1 through to 30, but also has 'SF' and 'GF'.

I need to ORDER it in a query so it's in the order: 1,2,3,...29,30,SF,GF

Is it possible to do this?

Thanks for any help,
~Oni.

[Piranha]

I think that this should work:

ORDER BY CASE column
   WHEN 'SF' THEN 2
   WHEN 'GF' THEN 3
   ELSE 1
END, column

[OniLink]

Thanks. I had to alter a few things, but it works.

Cheers.