If you ever need to sort character strings stored in SQL Server fields, ... (The example in this article applies to SQL Server 2000 and later.) ... SET @firstchar = SUBSTRING(@fullstring, ...