How many points do you lose for posting a question with the wrong answer? How about the sum of all the wrong answer. Can someone create a SQL statement...

Great question; it also really highlights the difference between Len() and DataLength(). For fun folks should try substituting Len for DataLength.

nChar(1) or Char(1) would be a better answer depending on your character set. Both Varchar(1) or nVarchar(1) have extra overhead to handle variable length strings which is not...