ahh, yes...but you didn't say mysql...sorry....they all have this function.
jeffrey_n_Dyke@Ke
ane.com To: <lgs@sarreid.com>
cc: php-db@lists.php.net
10/28/2003 05:16 Subject: Re: removing space ?
PM
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"
<lgs@sarreid.com> To:
<php-db@lists.php.net>
cc:
10/28/2003 05:11 Subject: 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
