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.

Now let’s say you want to find the balance of a company whose name includes the word Music. When you run the query, you would enter Music in the parameter query dialog box, as shown in Figure B.

Have a table (SQL Server 2008) that the user wants to record a fixed 8 character string in. At first glance, a CHAR seems the obvious selection since this value (an 8 character ID, two alpha ...