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 <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]