trim in select stmt

[bony_baba]

hi i am writing a quert to select all the columns from a table just like that select Eaton.* from Eaton eaton is my table name but some colums has blank spacesin left and right so i want to eliminate them so i use select Trim(Eaton.*) from Eaton but its not woking Whast i do if any body know Please help Thank in advance Thanks

[Reza Raad]

Use ltrim or rtrim as below: select lTRIM('Eaton.* ') between (')