Why can we define a integer datatype and pass an empty string in that gets evaluated to zero rather than NULL?


declare @testinteger integer
select @testinteger = ''
select @testinteger


How can we get this to eval to NULL?