The Length function in SQL is used to get the length of a string. This
function is called differently for the different databases:
- MySQL: LENGTH( )
- Oracle: LENGTH( )
- SQL Server: LEN( )
The syntax for the Length function is as follows:
Length(str): Find the length of the string str.
Let's take a look at some examples. Assume we have the following table:
WHERE store_name = 'Los Angeles';
SELECT region_name, Length(region_name)
Next: SQL Replace
|| Copyright © 2013 1keydata.com All Rights Reserved.