problem with text column and indexes

I have a table that I created and i am trying to create an index that contains a text field. I am having prblems with the syntax and keep receiving errors whenever I try to create the table. Here is the SQL statement for the table: CREATE TABLE IF NOT EXISTS logInfo ( ID BIGINT

Re: problem with text column and indexes

At 13:05 -0500 2/1/02, Diego, Emil wrote: I have a table that I created and i am trying to create an index that contains a text field. I am having prblems with the syntax and keep receiving errors whenever I try to create the table. Here is the SQL statement for the table: CREATE TABLE IF NOT