From: Jim Lyons (jlyons4435gmail.com)
Date: Fri Apr 17 2009 - 14:33:04 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Works for me. I assume you're only trimming blanks from the beginning
and/or end of the string. I have found that it will not trim tabs. Try a
command like:

select concat("'", trim(notes), "'") from work_notes

On Fri, Apr 17, 2009 at 2:17 PM, Richard Reina <richardrushlogistics.com>wrote:

> Hello All,
>
> I can't get trim to trim the blank space from a TEXT field in the query
> below and was wondering if someone could tell what I am doing wrong?
>
> SELECT TRIM(notes) FROM work_notes;
>
> Thanks for any help as I am at a complete loss.
>
> Richard
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=jlyons4435gmail.com
>
>

--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]