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 <[email protected]>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/[email protected]
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
