sort alphanumeric string using LINQ

Hi,

Does anyone know how to sort using linq-entity.


i use the following code:
from i in objEntities.Items
where ....
orderby i.Name
select i

The result is a1,a10,a11,a2,a3, b2,b21, b22,  c3....  But, i want it to be like a1,a2,a3,a10,a11, b2,b21,b22, c3...

This is very urgent. Please help me.

Check this post: http://www.interact-sw.co.uk/iangblog/2007/12/13/natural-sorting

Thanks a lot

This was very very usefull!

Another similar article found here:

http://zootfroot.blogspot.com/2009/09/natural-sort-compare-with-linq-orderby.html?showComment=1258020708758#c5034722582649839449

Thanks again