How to truncate an option/select list dropdown 1

[shamrox]

I have a select list dropdown that is populated from database records. The data is to long and I'd like to truncate it at say the 200th character and have ... at the end. Is this done in the sql statement? What would be the code to do this?

Thanks.

http://www.metrodesignworks.com

http://www.nowthatsodd.com/deadpool/

 

[sleipnir214]

You can do it in either an SQL statement or in your scripting language.

MySQL provides a left() function which will return the n leftmost characters of a string:

http://www.mysql.com/doc/en/String_functions.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!