Good question, but I feel compelled to point out that all statements would fail on a Case Sensitive Collation because the variable @b-2 is declared, but @b-2 is referenced. Also in example #5 @a is declared and @a is referenced.
In my opinion as rare as it may be to be in a case sensitive database, one should always be consistent in coding.
**** I'm not trying to bust your chops, just making a point. 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg