The FORMAT function lets you format any string or date to a specified format in an SQL Query. The syntax for the FORMAT function is: FORMAT ( string1, format ) string1 is the string to format format is the format
Instr – Access Function
The Instr function returns the position of the first occurrence of a string in another string. The syntax for the Instr function is: Instr ([ start ], string_being_searched , string2 , [ compare ] ) start is optional. It is
Lcase – Access Function
The lcase function turns all characters in a string to lowercase. The syntax for the lcase function is: lcase (string1) string1 is the string that is going to be made lower case. For example: Select lcase(“AlphaBet”) from dual would return
Replace – Access Function
The Replace function replaces a sequence of characters in a string with another set of characters (a number of times). The syntax for the Replace function is: Replace (string1, find, replacement, [start, [count, [compare]]] ) string1 is the string to
Ucase – Access Function
The ucase function turns all characters in a string to uppercase. The syntax for the ucase function is: ucase (string1) string1 is the string that is going to be made upper case. For example: Select ucase(“alphabet”) from dual would return