https://www.sqlines.com/ 2026-04-17T04:02:55+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2012-03-27T21:01:30+00:00 https://www.sqlines.com/teradata/functions/index?rev=1332882090&do=diff INDEX function returns the position (integer number) of a substring in a string. Quick Example: Find position of word York in string New York: SELECT INDEX('New York', 'York'); -- Result: 5 INDEX Overview Summary information: Syntax INDEX(string, substring) When Not Found Returns 0 when substring is not found in string Returns NULL If string or substring is NULL Alternatives POSITION function ANSI SQL compliant Different order of parameters Related Functions: text/html 2012-02-27T13:52:18+00:00 https://www.sqlines.com/teradata/functions/nullifzero?rev=1330350738&do=diff NULLIFZERO function replaces 0 values with NULL, and can be used to avoid division by zero, or to suppress printing zeros in reports i.e. Quick Example: Avoid division by zero: SELECT amount / NULLIFZERO(store_count) FROM sales; NULLIFZERO Overview Summary information: text/html 2012-02-29T10:07:32+00:00 https://www.sqlines.com/teradata/functions/position?rev=1330510052&do=diff POSITION function returns the position (integer number) of a substring in a string. Quick Example: Find position of word Jose in string San Jose: SELECT POSITION('Jose' IN 'San Jose'); -- Result: 5 POSITION Overview Summary information: text/html 2012-03-10T17:18:08+00:00 https://www.sqlines.com/teradata/functions/zeroifnull?rev=1331399888&do=diff ZEROIFNULL function replaces NULL values with 0. Quick Example: SELECT ZEROIFNULL(NULL); -- Result: 0 ZEROIFNULL Overview Summary information: Syntax ZEROIFNULL(expression) Alternatives CASE WHEN expression IS NULL THEN 0 ELSE expression END CASE is ANSI SQL compliant Related Functions: