>Using QUOTENAME did fix the error. Thanks!
>
>Why CHAR instead of VARCHAR? When should I use them?
>
If you're creating fields with fixed length use CHAR. If you don't know how much space your character field would occupy, use VARCHAR(). That's the quick explanation, it should be better explained in Help.
If it's not broken, fix it until it is.
My Blog