Solve Puzzle about Data type – SQL in Sixty Seconds #108


A very interesting puzzle, where you see the data type conversion in action. I have previously blogged about this puzzle and had received amazing feedback about it. Lots of people realize that they do not know why this particular behaviour is happening in the SQL Server.

Based on a request from the audience and friends, I have decided to build this video based on the puzzle. Let us see if you can solve this very fundamental yet extremely interesting puzzle or not.

Here is the script which I had used in this puzzle.

— Find your answer at — DECLARE @PhoneNumber VARCHAR(8) SET