[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] LENGTH(column) [color=green]FROM[/color] [color=orange]table[/color] [!--sql2--][/div][!--sql3--] OR [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] CHAR_LENGTH(column) [color=green]FROM[/color] [color=orange]table[/color] [!--sql2--][/div][!--sql3--] From: [a href=\"http://dev.mysql.com/doc/refman/5.0/en/string-functions.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/5.0/en/string-functions.html[/a] [quote] CHAR_LENGTH(str) Returns the length of the string str, measured in characters. A multi-byte character counts as a single character. This means that for a string containing five two-byte characters, LENGTH() returns 10, whereas CHAR_LENGTH() returns 5. CHARACTER_LENGTH(str) CHARACTER_LENGTH() is a synonym for CHAR_LENGTH(). [/quote