I cannot figure this out.

In the script I'm working on, a boolean variable can be dynamic either True / False ,etc

I cannot get the syntex correct to write this variable to a "binary" datatype column in SQL Server.

Column name in database is Binary

I have tried :

UPDATE da-database
SET Binary=@bStatus
WHERE First=400

da-databaseTEST

SET Binary=&bStatus
WHERE First=400

da-databaseTEST

SET Binary=bStatus
WHERE First=400

But if I use

da-databaseTEST

SET Binary=1
WHERE First=400

It sets the field to true i.e, Works correctly.  Just get get it going with a variable.