Your iter_intlist_to_table function should be preceded by "dbo.".

Brian, I replied to your other post but will reply here also.

The IN clause will not take a comma delimited list even though that is the way it looks when...

PS. You'll probably have to modify the table variable to return the datatype that matches your ID field.

EC

The IN clause will not take a comma delimited list even though that is the way it looks when you type in a list manually.

There are a couple of ways...

Answer 4 would only work if formatted properly:

CHECK (minit BETWEEN 'A' and 'Z' OR minit = ' ')

as opposed to the way it is written (notice the apostrophes):

CHECK (minit...