[SQL] How to manage category-ids as array-fields ?

Hi, I get from an outside source tables as simple textfiles to import. Those are obviously results of views with joined tables. Among the normal stuff are columns that have one or a list of id-numbers devided by a semicolon. In the next column there is the corresponding text for this ids. It

Re: [SQL] Create Table Problem

"Shavonne Marietta Wijesinghe" <[EMAIL PROTECTED]> writes: > IF (table not found) THEN > CREATE TABLE distributors ( > did integer, > namevarchar(40), > UNIQUE(name) > ); > END IF Assuming you're in a procedure (above code snippet looks to be executed within

[SQL] Create Table Problem

Hello I'm having some trouble checking if a table exist before i create it. Example: SELECT * FROM distributors IF (table not found) THEN CREATE TABLE distributors ( did integer, namevarchar(40), UNIQUE(name) ); END IF If i have a table like the above h