There is no direct answer to this question as this concept is present and used only in Stored Procedures and Macros in Teradata. But there are ways to replicate this functionality in the command prompt. As said before create a macro and pass a variable. Remember you can not use dynamic SQLs in a Macro. [...]

Putting ‘$’(Dollar) sign or ‘%’( Percent) sign is not a complex task as coming to a figure where you would like to have this prefixed or suffixed. So, first make sure the ground work is done. If you are calculating a division on the fly and the numerator is greater than the denominator than there [...]