@ChrisM@Work: Interesting approaches, but I'm wondering why you use DATALENGTH instead of LEN, are you trying to include trailing spaces? (In order to work with NVARCHAR instead of VARCHAR, you would need to divide DATALENGTH by two.)