can i use SQL sort by special expression?

my user want the data is sort by the field's content.
the content is "I","E","C","A" and BLANK
if just ascending and desc ,it's easy.
but now they want sort by this sequence "I","C","E","A" then blank
so how can i do it?
thank you
[252 byte] By [jetsu] at [2008-2-14]
# 1

SELECT * ;
,
at(data, "ICEA ") as
_ORDER ;
FROM table ;
ORDER BY
_order

Thierryp at 2007-9-8 > top of Msdn Tech,Visual FoxPro,Visual FoxPro General...
# 2
THIERRYP
THANK YOU
VERY MUCH
i am using sqlserver,does it have at() function?
jetsu at 2007-9-8 > top of Msdn Tech,Visual FoxPro,Visual FoxPro General...
# 3
For SqlServer, see Charindex() function.
Thierryp at 2007-9-8 > top of Msdn Tech,Visual FoxPro,Visual FoxPro General...
# 4
I GOT
THANK YOU
jetsu at 2007-9-8 > top of Msdn Tech,Visual FoxPro,Visual FoxPro General...