SqlServer-QA.net

I have seen many newbies asking ''How do I sort the numbers stored in varchar columns?'' Here are some methods declare @t table(data varchar(15)) insert into @tselect '6134' union allselect '144' union allselect '7345' union allselect '109812' union allselect '100074'union allselect '1290' union allselect '45764' --Method 1 select data from ...