Re: Copying and Converting a row

["Love, Kristin" <klove@MSA.COM>]

My first thought is:
update customer_contracts
set contract_id=(SELECT to_char(tracking_id) from .......where)

:) Kristin
> -----Original Message-----
> From: Michael Prodor [SMTP:mprodor@QUALCOMM.COM]
> Sent: Tuesday, July 20, 1999 10:02 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Copying and Converting a row
>
> 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)
>