Scalar functions in SQL?
Scalar functions return a single value by processing a single value in SQL. A few of the SQL scalar functions are,
UCASE() – Utilized to change over a string to uppercase
LCASE() – Utilized to change over a string to lowercase
ROUND() – Utilized to circular a number to the decimal places specified
NOW() – Utilized to get current framework date and time
LEN() – Utilized to discover the length of a string
SUBSTRING() or MID() – MID and SUBSTRING are equivalent words in SQL. They are utilized to extricate a substring from a string by indicating the beginning and conclusion list.
Syntax is SUBSTRING(ColumnName,startIndex,EndIndex).
LOCATE() – Utilized to discover the record of the character in a string.
syntax is LOCATE(character,ColumnName)
LTRIM() – Utilized to trim spaces from left
RTRIM() – Utilized to trim spaces from right