NULLIF works if I test for the empty string. That is not as nice as I would like but it meets the need. Thanks.

SELECT NULLIF(Field1, '') as Field1

, NULLIF(Field2, '')...

Since you are using SQL 2008 you can use a TVP to pass the integer data

CREATE TYPE dbo.InputContractsTable AS TABLE

(

Contracts int NOT NULL

)

GO

CREATE PROCEDURE [dbo].[GCI_PM_FileSubTypeGetBy_FileTypeAndContracts]

@FileTypeID INT,

@parInputContractsTable InputContractsTable...