Thread: strcat in sql

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    3
    Rep Power
    0

    strcat in sql


    hi,
    i need to do something as

    SELECT surname + " - " + name AS person FROM users

    but firebird give me an error...
    how can i do?
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    11

    Re: strcat in sql


    Originally posted by ciko
    hi,
    i need to do something as

    SELECT surname + " - " + name AS person FROM users

    but firebird give me an error...
    how can i do?
    Use double pipe || insted + !!!

    Try: SELECT surname || " - " || name AS person FROM users
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    3
    Rep Power
    0

    ok...


    it works...
    tnx a lot
  6. #4
  7. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    11

    Re: ok...


    Originally posted by ciko
    it works...
    tnx a lot
    ... all you have to do is to read the sql doumentation ...

IMN logo majestic logo threadwatch logo seochat tools logo