TRIM statement? Or TRIM function?

The TRIM function is useful for removing leading, trailing or both characters from a string.

Example:
[sql]
select trim(leading '1' from my_coumn) from my_table
[/sql]