INITCAP FUNCTION IN TERADATA

INITCAP FUNCTION IN TERADATA Dear Readers, In this article, we will learn about INITCAP FUNCTION IN TERADATA Purpose  Modifies a string argument and returns the string with the first character in each word in uppercase and all other characters in lowercase. Words are delimited by white… Read More

INSTR FUNCTION IN TERADATA

INSTR FUNCTION IN TERADATA Dear Readers, In this article, we will learn about INSTR FUNCTION IN TERADATA Purpose  Searches the source_string argument for occurrences of search_string. Syntax  TD_SYSFNLIB : the name of the database where the function is located. source_string: a character string or string… Read More

LENGTH FUNCTION IN TERADATA

LENGTH FUNCTION IN TERADATA Dear Readers, In this article, we will learn about LENGTH FUNCTION IN TERADATA Purpose  Returns the number of characters in the string argument. Syntax    TD_SYSFNLIB : the name of the database where the function is located. string : a character… Read More

LTRIM FUNCTION IN TERADATA

LTRIM FUNCTION IN TERADATA Dear Readers, In this article, we will learn about LTRIM FUNCTION IN TERADATA Purpose  Returns the string argument string1, with its left-most characters removed up to the first character that is not in the string argument string2. Syntax  TD_SYSFNLIB : The… Read More

OREPLACE FUNCTION IN TERADATA

OREPLACE FUNCTION IN TERADATA Dear Readers, In this article, we will learn about OREPLACE FUNCTION IN TERADATA Purpose  Replaces every occurrence of search_string in the source_string with the replace_string. Use this function either to replace or remove portions of a string. Syntax: TD_SYSFNLIB : the… Read More

OTRANSLATE FUNCTION IN TERADATA

OTRANSLATE FUNCTION IN TERADATA Dear Readers, In this article, we will learn about OTRANSLATE FUNCTION IN TERADATA Purpose  Returns source_string with every occurrence of each character in from_string replaced with the corresponding character in to_string. Syntax: TD_SYSFNLIB : the name of the database where the… Read More

POSITION FUNCTION IN TERADATA

POSITION FUNCTION IN TERADATA Dear Readers, In this article, we will learn about POSITION FUNCTION IN TERADATA Purpose  Returns the position in string_expression_2 where string_expression_1 starts. Syntax  string_expression_1 : a substring to be searched for its position within the full string. string_expression_2 : a full… Read More

REGEXP_SIMILAR IN TERADATA

REGEXP_SIMILAR IN TERADATA Dear Readers, In this article, we will learn about REGEXP_SIMILAR IN TERADATA Purpose Compares source_string to regexp_string and returns integer value. REGEXP_SIMILAR supports 2 or 3 parameters. Syntax TD_SYSFNLIB. Name of the database where the function is located. source_string A character argument.… Read More

REGEXP_SPLIT_TO_TABLE IN TERADATA

REGEXP_SPLIT_TO_TABLE IN TERADATA Dear Readers, In this article, we will learn about REGEXP_SPLIT_TO_TABLE IN TERADATA Purpose Splits source_string into a table of strings using regexp_string as the delimiter. Syntax: TD_SYSFNLIB. Name of the database where the function is located. inkey A numeric or character argument… Read More

RPAD FUNCTION IN TERADATA

RPAD FUNCTION IN TERADATA Dear Readers, In this article, we will learn about RPAD FUNCTION IN TERADATA Purpose  Returns the source_string padded to the right with the characters in fill_string so that the resulting string is length characters. Syntax  TD_SYSFNLIB : the name of the… Read More