I have the following: CREATE TABLE [Sections] ( [Department] varchar NOT NULL COLLATE NOCASE, [Course] varchar NOT NULL COLLATE NOCASE, [Section] varchar NOT NULL COLLATE NOCASE, [Class_Time] timestamp, [I_Id] varchar COLLATE NOCASE, [Room] varchar COLLATE NOCASE, CONSTRAINT [sqlite_autoindex_Sections_1] PRIMARY KEY ([Department], [Course], [Section]));
CREATE INDEX [PK_Sections] ON [Sections] ([Department], [Course], [Section]); In the programming language, I need to refer to the primary key as 1 field. Does Sqlite allow a 'calculated field', such as concatenation of the 3 columns in the PK? Or can I create a View to combine the 3? Any help is greatly appreciated. Thanks, Bradley _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users