On Fri, Feb 29, 2008 at 11:52 AM, Alessio Forconi <[EMAIL PROTECTED]> wrote:
> Hello everyone,
>
> SELECT IDStudent, Name + " - " + Surname AS Nominative FROM Students
+ is addition. You want ||. Also, you're using double-quotes (") when
you should be using single-quotes (').
SELECT IDStudent, Name || '.' || Surname
--
-- Stevie-O
Real programmers use COPY CON PROGRAM.EXE
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
