This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 71%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
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?
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!
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. :)
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.