On 20 Feb 2004 at 14:55, Dan Nelson wrote:
> If you need leading and trailing space stripped, you can postprocess
> the field with the TRIM() function.
But note that, unlike similar functions in some languages, the MySQL
TRIM() function removes spaces (ASCII 32 characters), not whitespace
(which generally includes tabs, carriage returns, and line feeds --
and sometimes vertical tabs, form feeds, or nulls -- along with
spaces).
--
Keith C. Ivey <keith@stripped>
Tobacco Documents Online
http://tobaccodocuments.org
