CAST ( expression AS data_type [ ( length ) ] )
ISNULL ( check_expression, replacement_value )
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
Simple CASE function:
CASE input_expression WHEN when_expression THEN result_expression [ ...n ] [ ELSE else_result_expression ] END
CASE WHEN boolean_expression THEN result_expression [ ...n ] [ ELSE else_result_expression ] END
CONTAINS ( searched_expression, find_expression )
LASTIDENTITY ( column_name [ , table_name ] )
LASTTIMESTAMP ( 'table_name' )
COALESCE ( expression, n )
NEWID ( )
SP_RENAME ( 'object_name', 'new_name', 'object_type' )
NULLIF (expression, expression)