trim a tab from a column (was "Query Help")

[OptMediaJohn]

I am trying to do a trim() on a column that includes a tab after every entry. However, I am having trouble making the statement syntax.

Here is what I have:

members_ = table
fullname = column that includes the data I want to trim


Select fullname_ from members_ and TRIM(BOTH ' ' members_);

This is the last query I tried, however I get syntax error. I am not very skilled in sql, so any help is appreciated.

Thanks,

John

[r937]

what database are you using?

[swampBoogie]

select trim(trailing '<tab-character>' from fullname_) from members_

That's standard SQL.