>
>
>> I am trying to trim both leading and trailing whitespace from a TEXT
>> column in my SELECT query. I found the TRIM() command in the manual,
>> however, I can't get it to act upon a column name instead of an
>> actual string. Can anyone help?
>
>
> If you just say TRIM(col_name) it will return the trimmed column value,
> but it won't change the column itself. Try updating the column to its
> trimmed value:
>
> UPDATE tbl_name SET col_name = TRIM(col_name);
I tried both ideas and neither one removed the white spaces. arrr! :-(
>
>>
>> Thanks,
>>
>> Richard
>
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
