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
