Sql server datatype values issue

Hi,

Here Implicit conversions (Those are invisible to the user) are done....
SQL Server automatically converts the data from one data type to another when required. if a smallint is compared to an int, the smallint is implicitly converted to int before the comparison proceeds. so here also SQL server trying to convert TransactionType type to interger. but If SQL server fail to cast it value to interger than it raise the error....

for exaple
try following code

declare @t varchar(50)
set @t = '0898'
If(@t = 1)
 print 'True'
else
 print 'False'

It return "False", when comparision is happend, SQL server trying to cast the value of @t to interger...

now try following code

declare @t varchar(50)
set @t = '08a8'
If(@t = 1)
 print 'True'
else
 print 'False'

so at this time SQL server return error "Conversion failed when converting the varchar value '08a8' to data type int."