Any form of function on a column will prevent index seeks on that column. So if you use that form in a where/join, you may very well be hindering performance.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability