Re: removing space ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux