if you're using mysql you can use LEFT(column_name, 10) this will return the first 10 chars of whatever is in column_name. you could also use SUBSTRING(col, position, length)... i'm sure most DB's support variations of the above. hth jeff "Dallas Freeman" To: <php-db@lists.php.net> <dally2001@big cc: pond.com> Subject: Cropped Text 03/12/2003 04:21 PM I dunno what it is called so that is why I am asking, so that I can search the web about it. What do you call the method of cropping text back, so that there are a limited number of characters shown, the rest is cut off. Thanking You, Dallas Freeman -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php