NEVER use VARCHAR without a length on #SQLServer. Why? Try this, you will be surprised: DECLARE @test1 VARCHAR(100) = 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'; SELECT LEN(@test1); PRINT @test1; 1/n