CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. September 8th, 2005, 04:31 PM #1
    sa_keles
    sa_keles is offline Member
    Join Date
    Aug 2005
    Location
    Kocaeli/TURKEY
    Posts
    69

    Question sql select problem?

    SELECT
    user_name|| " " || user_sname
    FROM
    users

    i am trying to concat this two column but i has problem near the "|"
    any idea?
    Reply With Quote Reply With Quote
  2. September 8th, 2005, 04:45 PM #2
    wildfrog's Avatar
    wildfrog
    wildfrog is offline Elite Member
    Join Date
    Apr 2005
    Location
    Norway
    Posts
    3,934

    Re: sql select problem?

    Try this instead:
    Code:
    SELECT (user_name + ' ' + user_sname) FROM users
    - petter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured