A few days ago I was asked to look over some SQL statements written by someone new to SQL. They were getting some unexpected results when concatenating strings and although they had managed to overcome the issue, they asked that inocent question we all love to ask and hate to be asked; ‘Why?’