InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 13:30:36 GMT20http://www.sqlservercentral.com/Forums/Topic1296666-1049-1.aspxSorry but i cant provide one.A friend requested that i'll send him the functions ASAP. after it was done i remembered i posted something similar a few years back so i loaded those two as well.Tue, 22 May 2012 09:16:06 GMTbester.oferhttp://www.sqlservercentral.com/Forums/Topic1296666-1049-1.aspxI agree - the two functions can be merged easily.I intentionally did not mix the two to enable a clear understanding.Tue, 22 May 2012 09:13:27 GMTbester.oferhttp://www.sqlservercentral.com/Forums/Topic1296666-1049-1.aspxUse-case?Part of what makes SQLServerCentral articles interesting to read is the story that explains the code. What prompted you to write these functions?Even if this solution "works" - what problem does it solve?Why is this solution better than the approach *I* might have created?(I'd probably not think to write/employ the functions you've written)Summary: "more please" :)Tue, 22 May 2012 08:05:24 GMTMike Dougherty-384281http://www.sqlservercentral.com/Forums/Topic1296666-1049-1.aspxUm, give the function a parameter so it can do either on or off. Two functions for this is a no no.Tue, 22 May 2012 07:36:49 GMTjfogelhttp://www.sqlservercentral.com/Forums/Topic1296666-1049-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Bit+operation/90373/">Turn varbinary bit ON/OFF</A>[/B]Tue, 08 May 2012 12:06:08 GMTofer bester