Post reply

Update table using UPPER function

  • November 13, 2007 at 3:40 am

    #75812

    Hi Guys, I need to update the POST_CODE feild of a table by converting all the data records in the feild to upper case. Any ideas of how this could be done in an update statement?

    many thanks

  • November 13, 2007 at 4:22 am

    #750560

    Mark Stewart (11/13/2007)

    Hi Guys, I need to update the POST_CODE feild of a table by converting all the data records in the feild to upper case. Any ideas of how this could be done in an update statement?

    many thanks

    UPDATE myTable SET post_code = UPPER(post_code)

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • November 13, 2007 at 4:43 am

    #750570

    Thanks

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

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