https://www.sqlines.com/ 2026-05-14T16:39:53+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2012-02-29T09:32:40+00:00 https://www.sqlines.com/teradata/functions?rev=1330507960&do=diff The reference and articles provide detailed technical information on built-in SQL functions in Teradata database. Last Update: Teradata 13 All Functions Functions in alphabetical order: INDEX Get position of substring in string NULLIFZERO Replace 0 values with NULL ZEROIFNULL Replace NULL values with 0 String Functions String functions: text/html 2012-02-24T11:01:37+00:00 https://www.sqlines.com/teradata/mode?rev=1330081297&do=diff You can use a SQL query, SQL or BTEQ statement to find out the current mode: Teradata or ANSI. SQL Query You can query transaction_mode column of dbc.sessioninfo to get the current mode for the specified session. A is returned if the mode is ANSI, and T if the mode is Teradata. text/html 2012-02-27T11:48:11+00:00 https://www.sqlines.com/teradata/not_casespecific?rev=1330343291&do=diff NOT CASESPECIFIC (abbreviated form - NOT CS) attribute specifies that string comparison is case-insensitive, while CASESPECIFIC (CS) specifies case-sensitive comparison. Quick Example: -- Create a table with one column case-insensitive, another column case-sensitive CREATE TABLE cities ( name VARCHAR(80) NOT CASESPECIFIC, name2 VARCHAR(80) CASESPECIFIC ); -- Insert a row INSERT INTO cities VALUES ('San Diego', 'San Diego'); -- Name column is case-inse…