>Without yet looking too close I see a very common mistake here
>
>

>DECLARE @LocID char = 'N-18'
>DECLARE @Class integer = 2

>
>Read this blog post about the problem:
>
>http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/always-include-size-when-using-varchar-n/
>

That did it. Thanks. I will have some more questions for you on Monday.