Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006
    Posts
    5

    Unanswered: How to convert Integer to Varchar in Db2

    I want to convert Integer value to Varchar in DB2 How to do it.
    Please help thanks in advance

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    varchar

    if it is for a select then :
    select varchar(colname,25)
    if for permanent then
    export ... select varchar(colname,xxx) ......
    drop table/create table with varchar column
    import/load data back to table
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •