>
>
>> 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 wil
On 7 Feb 2002, at 8:20, Richard Reina wrote:
> I tried both ideas and neither one removed the white spaces. arrr!
> :-(
Unfortunately TRIM doesn't remove whitespace (spaces, tabs, carriage
returns, linefeeds), as it does in some programming languages. It
just removes spaces, unless you specif
At 16:17 -0800 2/6/02, Richard Reina wrote:
>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 jus
On 7 Feb 2002, at 8:20, Richard Reina wrote:
> I tried both ideas and neither one removed the white spaces. arrr!
> :-(
Unfortunately TRIM doesn't remove whitespace (spaces, tabs, carriage
returns, linefeeds), as it does in some programming languages. It
just removes spaces, unless you specif
>
>
>> 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 wil
At 16:17 -0800 2/6/02, Richard Reina wrote:
>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 jus
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?
Thanks,
Richard
--