At 12:05 PM 04-01-02 +0900, you wrote:

>I want to use substring() like this...
>
>select * from test_table order by substring(name,1,5) ASC;
>
>How can i do??????

What database and version are you using? (InterBase? Firebird? version?)

Also - please would you set up your mail program NOT to send HTML?

Thank you.

Helen

>
>
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
><http://rd.yahoo.com/M=216105.1806326.3318126.1261774/D=egroupweb/S=1706030389:HM/A=915130/R=0/O=1/I=brandr-lrec/postholidaygroup/*http://shopping.yahoo.com/domain?d=holiday&cf=posthol01>3859637.jpg
>3859728.jpg
>
>To unsubscribe from this group, send an email to:
>IB-Conversions-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the <http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________