SQL Text literal values consist of any valid SQL text and are placed in the SQL “as-is” without formatting. When dragging a literal Text value into a variable, the following tree element is created.
No default text is provided - use the Properties panel to change it. Double-click on Text or highlight and click Properties.
Type in any valid Teradata SQL text.
An example of a SQL Text literal might be a hexadecimal literal such as '00'XC, or a literal string with more than one quote, such as ‘If it isn’’t broken, don’’t fix it’.
Standard right-click menu options are available within the text box, namely Undo, Cut, Copy, Paste, Delete and Select All. Note, however, that the Paste option will convert a columnar list of values separated by carriage returns into a comma separated list, making it easier to copy values from other tools such as Microsoft Excel. Conversion of the values into valid Teradata literals are attempted for each of the incoming values, first into various numeric types, then if these fail, into date values; finally, if these conversions fail, the values are converted into a list of String literals.