[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] How To concatenate two fields in one
From:       Dennis Cote <dennis.cote () gmail ! com>
Date:       2008-02-29 21:42:51
Message-ID: 47C87C5B.4010207 () gmail ! com
[Download RAW message or body]

Alessio Forconi wrote:
> 
> What I would like to achieve is the same as writing in SQL Server
> 
> SELECT IDStudent, Name + " - " + Surname AS Nominative FROM Students
> 

You need to use the SQL standard concatenation operator.

    SELECT IDStudent, Name || " - " || Surname AS Nominative
    FROM Students

HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]