Depending on the database you are using Substring() Substr() Functions do what you want jack -----Original Message----- From: Shaun [mailto:shaun@mania.plus.com] Sent: Friday, August 29, 2003 11:58 AM To: php-db@lists.php.net Subject: SELECT Part of a Field Hi, How can I SELECT a portion of a field in a table for example the first character, or the second two characters etc? Thanks for your help -- 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