Can anyone tell me how to pass a FALSE to a stored procedure in SQL Server. At the moment I am trying the following syntax from the query window in SQL Server, when I get that to work I will run it trough an SQLEXEC:

sp_NewCustomer (0)

I keep getting the following error message:

Msg 170, Level 15, State 1
Line 1: Incorrect syntax near '0'.

My stored procedure is expecting to recieve one parameter of type BIT. This may turn out to be something really basic, but I just can't figure it out.

Steve Camsell
Development Consultant
Steve.Camsell@Windmill-DBM.Co.Uk