Thanks all for the input and direction. I think I'm going to try and do it both ways to see what the difference is in the execution plans.

Thanks for the link.

I guess what I thought what was interesting was the io results between the LIKE operator and a hard-coded value vs the LIKE operator and a variable.