sql - Sort varchar column starting with the first letter instead of the first character? -


using linq or sql, how have following strings, sorted as:

"banana" apple coconut

sort as:

apple "banana" coconut

updated based on comment

ilist<string> sorted = context.terms.tolist()     .orderby(t => regex.replace(t.term, @"\w*","")).tolist(); 

Comments

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

java - Android recognize cell phone with keyboard or not? -

iphone - How would you achieve a LED Scrolling effect? -