Re: removing space ?

From: Date: Tue, 28 Oct 2003 22:16:01 +0000
Subject: Re: removing space ?
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-31339@lists.php.net to get a copy of this message
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

« previous php.db (#31339) next »