In sqlsever, this statement is success..

' select * from person order by substring(account,1,2) asc ;'

But In firebird , it's failed...

I want to user substring In order by clause....
How can I do????

I know this statement and it's success in firebird..

' select substring(account from 1 for 3 ) from person'

I want to user substring in order by clause like this..

' select * from person order by substring(account,1,2) asc '






===========================================================================
우리 인터넷, Daum http://www.daum.net
- 2002 대입 1:1상담,원서접수,합격자발표 ☞ http://hmm.daum.net/daeip_0112
- 인터넷에서 '토정비결' 보세요~ ☞ http://hmm.daum.net/fortune_0112