InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 15:35:43 GMT20http://www.sqlservercentral.com/Forums/Topic1401799-391-1.aspx[quote][b]lathish2kumar (1/2/2013)[/b][hr]ERROR:The data types varchar and bit are incompatible in the add operator. CAN ANY ONE KNOW WHAT TYPE OF ERROR IS THISCAN U FIND IT PLS[/quote]It is in your code, which you didn't post. Hard to help you find it when we can't see it. Also, please use your inside voice, there is no need to yell. (In other words, drop the typing in ALL CAPS.)Wed, 02 Jan 2013 06:48:17 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1401799-391-1.aspxYou'll have to CAST one of the data types to one or the other in order to combine them.Wed, 02 Jan 2013 06:39:18 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1401799-391-1.aspxYou cant add a bit to a varchar or a varchar to a bit.What are you trying to do, string concatenation?Please provide details of your task at hand.Wed, 02 Jan 2013 05:57:28 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1401799-391-1.aspxERROR:The data types varchar and bit are incompatible in the add operator. CAN ANY ONE KNOW WHAT TYPE OF ERROR IS THISCAN U FIND IT PLSWed, 02 Jan 2013 05:53:16 GMTlathish2kumar