LENGTH(RTRIM(SPACE(8))) : LENGTH « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. LENGTH

LENGTH(RTRIM(SPACE(8)))

      
mysql>
mysql> select LENGTH(RTRIM(SPACE(8)));
+-------------------------+
| LENGTH(RTRIM(SPACE(8))) |
+-------------------------+
|                       0 |
+-------------------------+
1 row in set (0.00 sec)








Related examples in the same category

1.LENGTH Function
2.LENGTH(CONCAT(CAST(100000 AS CHAR(6)),'000'))
3.Length of trimmed varchar value
4.The length of the shortest verse in the King James Version, that's easy to find
5.Get cases name and length in the production dept
6.Preserving Trailing Spaces in String Columns
7.Determine how many bytes are necessary for storing the data.
8.Lists names from the names table with the longest names first