I have this section in a sp: IF @v_TotalNewAmt > @p_AquiredFor SET @p_ErrMsg = "Total Funded will go over 100% with this transaction.There is currently: " SET @p_TotalAmtLeft = @p_AquiredFor BEGIN ROLLBACK TRANSACTION RETURN @@ERROR END Both the "@v_" are money variable types. No matter what I do the code in the If statement is executed. I have even just tried "IF 1>2" but it still will return @p_TotalAmtLeft and stop the transaction. Also can you concatenate with TSQL? I am pretty new to TSQL so I am not sure what I am doing wrong.