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
Post a Comment