Home Forums SQL Server 2008 T-SQL (SS2K8) 0 is equal to zero length string. Can someone explain how this can be? RE: 0 is equal to zero length string. Can someone explain how this can be?

  • August 7, 2012 at 7:52 am

    #1522607

    You might find this article interesting.

    http://msdn.microsoft.com/en-us/library/ms190309.aspx

    So you won't have to wait for Celko to "do some digging". Here are the exact rules for implicit conversion in SQL Server. It's not a T-SQL error, it's just the way it's designed.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2