Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006
    Posts
    17

    Unanswered: Concat more than one columns?

    Hi,

    i want to select 2 integer and a varchar fields as one. How can i do it?
    Any ideas?
    thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Select concat(concat(char(intcol1),char(intcol2)),varchar col) from ...

    Andy

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    you can also write:
    Select char(intcol1) concat char(intcol2)) concat varchar_col from
    Hope this helps,
    Grofaty

Posting Permissions

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