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
