c# - how to convert bit datatype to varchar in sql -

How to change bit datatype into SQL in the worker?

I tried Cast

Note:

has been removed as CAST (Varchar (512))

But that does not work ....

Note: IsDeleted is a bit datatype and it is Varchar or Int

Assume this is MySQL, you can VARCHAR can not be cast on Acceptable types are shown; Those CONVERT functions are listed after the clarification.

You will enter CHAR (1) . For example:

  CAST (b'11 'AS CHAR (1))