COALESCE is a very useful function, if you want to build a string of data from a field in a database table.

If you just upgraded your database to SQL Server 2008, you want your database to be compatible with SQL 2008, of course. To see which compatibility your database currently has, just type the following query (new in SQL Server 2008):