Thanks for the help and input. I actually got it to work by using the unicode prefix N'.

DECLARE @return_value int,

...

Thank you ColdCoffee and Lowell! This is exactly what I was looking for. 😀

Thank you for the tip on Check Constraint. That will work, except should I consider a different datatype if the data is a 3-digit number, including leading zeros? ...

Thanks for all of your help. The alias works. As for why I must use the alias in my PROD enivoronment, I'll keep searching.

Thanks, again!

But is there any reason why this would work in one environment and not the other, when both environments are identical?

Both databases are SQL Server 2005, compatibility (90)

Lynn - The tables are set up the same, as with the collations. I actually built the DEV version from the PROD one recently.

Blake - I don't know why,...

First of all, I apologize for the previous 3 posts. I kept getting an error when I previewed my post and then tried to post it. I tried...

Can

Can

a