Comments
-
This is not possible, however you can format the number in a dataflow. CONCAT('$', FORMAT(Amount, 2)) Amount
-
Not sure I understand. SET @bob:='bob'; SELECT * FROM table WHERE name=@bob; I will follow-up with support, but for completeness, the above SQL gives the following error "SQL statement must be a SELECT clause if "Generate Output Table" is selected."