If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.

-- 1) Write an SQL query to print the first three characters of Country_name from the Country table. select Country_name, LEFT(Country_name, 3) as 'First 3 characters of Country_name' from Country; -- ...

I need to query against a column which contains build numbers stored as an NVARCHAR.Sorting works fine until you get into double-digit versions.This works ...

Alright, I have an odd problem.I need to sort by two columns, but not in the standard first one column, then the next column...Basically I have a database ...