How do I trim() a column?

[mwolf00]

What is the command that trims off extra whitespace from a column? In T-SQL, I would say "SELECT trim(firstName) FROM myTable"...

Can this be done?

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[mwolf00]

Doh- foung it - sorry

RTRIM()

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[nickpark]

ltrim, too

 

[mudharan]

select ltrim(rtrim(field_name)) from table_name.