Another one of these choices... to go with a char or varchar for a field. Not really an issue with space since we are only looking at a couple of thousand records or so but just wondering what the ...

If you ever need to sort character strings stored in SQL Server ... (The example in this article applies to SQL Server 2000 and later.) CREATE FUNCTION dbo.udf_Swap ( @fullstring VARCHAR(1000), ...