there are trim functions in both mysql and php. both they are called the same...trim, ltrim and rtrim. trim takes off both sides, and the r and l take the right and left respectively, but yes, this is possible in the query.
http://www.mysql.com/doc/en/String_functions.html php.net/trim php.net/ltrim hth Jeff "Larry Sandwick" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> cc: 10/28/2003 05:11 Subject: [PHP-DB] removing space ? PM Please respond to lgs When I select data from my data base I have spaces on the lead side for example the data that is stored is " 33.jpg". Spaces included, exclude the quotes, quotes are example only to show the spaces. I would like to remove these spaces. Is there a way to do this? Can it be done in the query? Any help would be appreciated. Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php