In order to know the measurement lengthwise of a specific string, a function ‘Length’ is used in SQL. The way of calling the function in databases is dissimilar to each other.
• MySQL: LENGTH()
• Oracle: LENGTH()
• SQL Server: LEN()
Here is the basic structure for this function:
Length(str): It is used for locating the length of ‘str’.
Here is a table, through which we will understand this function;
West Los Angeles
West San Diego
East New York
WHERE store_name = 'Boston';