Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Find Longest word

Author  Topic 

satish.gorijala
Posting Yak Master

182 Posts

Posted - 2009-07-02 : 03:31:52
Is there some function in sql to sort by longest word..like by most number of characters in a name.

i.e like..we can sort a through z
i want to sort by least characters to max characters


G. Satish

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-07-02 : 03:35:30

Order by len(col) desc

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

satish.gorijala
Posting Yak Master

182 Posts

Posted - 2009-07-02 : 03:37:54
This is the thing what i am looking for. its perfect. Thank you...

G. Satish
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-07-02 : 03:46:20
quote:
Originally posted by satish.gorijala

This is the thing what i am looking for. its perfect. Thank you...

G. Satish


You are welcome

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -