LENGTH(CONCAT(CAST(100000 AS CHAR(6)),'000')) : LENGTH « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. LENGTH

LENGTH(CONCAT(CAST(100000 AS CHAR(6)),'000'))

      
mysql>
mysql> select LENGTH(CONCAT(CAST(100000 AS CHAR(6)),'000'));
+-----------------------------------------------+
| LENGTH(CONCAT(CAST(100000 AS CHAR(6)),'000')) |
+-----------------------------------------------+
|                                             9 |
+-----------------------------------------------+
1 row in set (0.00 sec)

mysql>








Related examples in the same category

1.LENGTH Function
2.LENGTH(RTRIM(SPACE(8)))
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