Postgres – String Functions and Operators in PostgreSQL

Below are some of the functions

ASCII – Return the ASCII code value of a character
CHAR – Convert an ASCII value to a character
CHARINDEX Search for a substring inside a string starting from a specified location and return the position of the substring.
CONCAT Join two or more strings into one string
CONCAT_WS Concatenate multiple strings with a separator into a single string
DIFFERENCE Compare the SOUNDEX() values of two strings
FORMAT Return a value formatted with the specified format and optional culture
LEFT Extract a given a number of characters from a character string starting from the left
LEN Return a number of characters of a character string
LOWER Convert a string to lowercase
LTRIM Return a new string from a specified string after removing all leading blanks
NCHAR Return the Unicode character with the specified integer code, as defined by the Unicode standard
PATINDEX Returns the starting position of the first occurrence of a pattern in a string.
QUOTENAME Returns a Unicode string with the delimiters added to make the input string a valid delimited identifier
REPLACE Replace all occurrences of a substring, within a string, with another substring
REPLICATE Return a string repeated a specified number of times
REVERSE Return the reverse order of a character string
RIGHT Extract a given a number of characters from a character string starting from the right
RTRIM Return a new string from a specified string after removing all trailing blanks
SOUNDEX Return a four-character (SOUNDEX) code of a string based on how it is spoken
SPACE Returns a string of repeated spaces.
STR Returns character data converted from numeric data.
STRING_AGG Concatenate rows of strings with a specified separator into a new string
STRING_ESCAPE Escapes special characters in a string and returns a new string with escaped characters
STRING_SPLIT A table-valued function that splits a string into rows of substrings based on a specified separator.
STUFF Delete a part of a string and then insert another substring into the string starting at a specified position.
SUBSTRING Extract a substring within a string starting from a specified location with a specified length
TRANSLATE Replace several single-characters, one-to-one translation in one operation.
TRIM Return a new string from a specified string after removing all leading and trailing blanks
UNICODE Returns the integer value, as defined by the Unicode standard, of a character.
UPPER Convert a string to uppercase

sql tutorial,learn sql,sql for beginners,sql basics,sql tutorial for beginners,#SQL,structured query language,introduction to sql,#RDBMS,#PGClient,Learn SQL,#postgres,#postgresql tutorial,#postgres tutorial,#what is postgresql,#what is postgres,#postgresql tutorial for beginners,#postgresql course,postgres,postgresql,postgresql tutorial,postgres tutorial,what is postgresql,what is postgres,history of postgresql,postgressql,postgresql tutorial for beginners