Msg 245, Level 16, State 1, Line 6 Conversion failed when converting the nvarchar value 'N' to data type bit.

Msg 245, Level 16, State 1, Line 6

Conversion failed when converting the nvarchar value 'N' to data type bit.

Sometimes we get bit values as Y and N also instead of 0 and 1. If we declare the column as Bit and we receive values as Y or N we get the above error.

Alter the column by updating the column data type to varchar(1) will fix the issue.

alter table contractlinesummary

alter column [ThirdPartyFlag] varchar(1) null