Hi, you can also build a new table based on a cursor with following SELECT:

SELECT

column_name=c.name,

datatype=t.name,

length=c.length

FROM sysobjects AS o

INNER JOIN syscolumns AS c

ON o.id = c.id

INNER JOIN systypes  AS...

MSAccess can't handle a SQL (or any other type of 'linked' table) if it has no way to identify any row with a unique id, that is: you MUST have...

Hi Mark, that's true, but all the nulled values will be evaluated once, during the parse of the query, so I think the execution time will not be affected.

Luigi

There's another way to handle this problem:

Create Procedure myProc

  @cond1 varchar(1) )= null

  @cond2 int = null

AS

SELECT * FROM MyTable

WHERE