Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Varchar Order By
Ideally I would have two columns but I do have other values in this column (int, decmial etc). For this ORDER BY instance the selected field will always have a space so, thank you for your help here it works perfectly! -
Varchar Order By
Hi! After a vast amount of hunting I've come to no resolution to my dilemma. I have a varchar(20) table column containing values similar to this: Alpha 1 Alpha 2 Alpha 3 Alpha 10 Alpha 12 Beta 1 Beta 2 Beta 3 Beta 15 ... ... With a straight forward ORDER BY field it outputs the following...
