Copying and Converting a row

[Michael Prodor <mprodor@QUALCOMM.COM>]

I'm trying to write an SQR that takes a row and copies it to another row.
The catch is that the row being copied is a Number and the row being copied
to is a Character row.

My first thought was this:

update customer_contracts
set contract_id = TO_CHAR(tracking_id)

but is there a better way?

Any help would be appreciated!

Michael Prodor
<mprodor@qualcomm.com>

Qualcomm - OMNI Info Systems