Post reply

alter column

  • August 16, 2005 at 5:43 am

    #110078

    Hi guys,

    I'm trying to populate a column in a table with values from another column on the same table i.e. i have two columns namely column A and column B respectively, I want to populate column B with values from column A on the same table. How can i achieve this? Your prompt response is greatly appreciated.

    Cheers

    M

  • August 16, 2005 at 6:21 am

    #582400

    Are they the same type??

    Update table set colb = cola

  • August 16, 2005 at 6:31 am

    #582404

    luckily yes they are, and it worked thanks

  • August 16, 2005 at 6:47 am

    #582414

    HTH.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply