I know that like this...

' select substring(account from 1 for 3 ) from vuser where account ='shyang'; '

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

'select account from vuser order by substring(fullname from 1 for 3) asc ; '

But in interbase, this statement failed...
How can i do????


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