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?

You can definitely do this and should do this in the query. Most database applications have a TRIM() function or something like it. You don't mention what database application you're using so I can't be more specific but just check the manual for your database.


Larry

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to