Home Forums SQL Server 2005 SQL Server Newbies Does the string in a field contain a capital 'H' or 'D' in the left 3 characters - Scalar Function returns T/F RE: Does the string in a field contain a capital 'H' or 'D' in the left 3 characters - Scalar Function returns T/F

  • December 17, 2014 at 11:30 am

    #1765253

    Yes, it's intended to look simpler as the conditions are reduced by half. Note that I changed the collation, basically because I have a case insensitive collation and because binary collations are faster than others.

    It's a good thing that you were able to learn something from this. 😉

    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