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.