How to convert CHAR(1) to BIT in SQL SERVER

Question

How to convert CHAR(1) to BIT in SQL SERVER

Ramana Kopparapu 306

Hi, I have two tables emp_source and emp_target. In Source I have 3 columns id INT Name VARCHAR(20) Gender CHAR(1) Target Table: Id INT Name VARCHAR(20) Gender BIT Assuming if Gender is 'M' which is equal to 1 and Gender is 'F' which is equal to 0 While trying to load data to Target table using MERGE Statement getting the error. Conversion failed when converting the varchar value 'M' to data type bit.. Could anyone please look into this and respond?

LiHongMSFT-4306 31,621 Reputation points

2024-02-05T02:52:00.2633333+00:00

Hi @Ramana Kopparapu We haven't heard any response from you yet.

Is this issue solved now? If you have any questions, please feel free to share with us.

And don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

Thanks for your understanding!
LiHongMSFT-4306 31,621 Reputation points

2024-02-29T05:37:59.3933333+00:00

Hi @Ramana Kopparapu Do you have further question on this issue, could we offer more support?

If any answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Answer accepted by question author

0 additional answers

Your answer

LiHongMSFT-4306 31,621 Reputation points

2024-02-05T02:52:00.2633333+00:00

Hi @Ramana Kopparapu We haven't heard any response from you yet.

Is this issue solved now? If you have any questions, please feel free to share with us.

And don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

Thanks for your understanding!
LiHongMSFT-4306 31,621 Reputation points

2024-02-29T05:37:59.3933333+00:00

Hi @Ramana Kopparapu Do you have further question on this issue, could we offer more support?

If any answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Answer 1

Viorel 126.7K

Try this expression: case Gender when 'M' then 1 when 'F' then 0 end. Use it in the corresponding parts of MERGE, or show details.

Share via

How to convert CHAR(1) to BIT in SQL SERVER

0 additional answers

Your answer