IF...ELSE (Transact-SQL)

The Transact-SQL statement that follows an IF keyword and its condition is executed if the condition is satisfied: ... (CAST(@compareprice AS varchar(20)))+'.' END ELSE PRINT 'The prices for all products in this category exceed $'+ RTRIM(CAST(@ .

msdn.microsoft.com