try to find a function to get only numbers for example select Split(ColName," ")
and convert the result to number then sort by the resulting column
or
divid the column into two coumns @ID , @Name
rkmnm <[EMAIL PROTECTED]> wrote:
rkmnm <[EMAIL PROTECTED]> wrote:
how to sort this query in ascendint order
col Name
============================
1 ram
10 kumar
11 mohan
2 sunil
3 mohabn
20 kamal
result require in format
col name
============================
1 ram
2 sunil
3 mohabn
10 kumar
11 mohan
20 kamal
plz send this query
Mostafa A.Basha
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
YAHOO! GROUPS LINKS
- Visit your group "Microsofts_C_Sharp" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
