Use the standard SQL || operator for concatenate. The + is not SQL and specific to SQl Server.
Alessio Forconi wrote: > Hello everyone, > > This is my first message. > > I have a table called Students: > > IDStudent char(10) PRIMARY KEY, NOT NULL > Name char (30) NOT NULL > Surname char(30) NOT NULL > > > What I would like to achieve is the same as writing in SQL Server > > SELECT IDStudent, Name + " - " + Surname AS Nominative FROM Students > > > In SQL Server the results is: > IDStudent Nominative > MICA-00 Michele - Calzolani > > Unfortunately in SQLite I get this: > DStudent Nominative > MICA-00 0.0 > > I do not understand where the error is, someone can help me? > > I apologize for my bad English > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
