Results 1 to 3 of 3

Thread: Integer -> Str

  1. #1
    Join Date
    Jun 2003
    Posts
    2

    Integer -> Str

    Hi, I am working with Informix, and I need to use a function which may convert integer to char string. Is there somebody who can help me? Thanks!

  2. #2
    Join Date
    Mar 2003
    Location
    NJ
    Posts
    201
    Did you try "Convert" and "Cast"(I am not sure whether these 2 work for you or not)

    Here are examples of both!
    seletc convert(varchar(4),1234)
    select cast(1234 as varchar(4))

  3. #3
    Join Date
    Jun 2003
    Posts
    2

    Talking Thanks

    Thanks!!! It works!
    I mean CAST, and I found a system table - SYSCASTS, where you can find all system converted types!! Thanks a lot again!
    Have a nice day!

Posting Permissions

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