Subhro

This is something that's best done by the presentation layer of your application, rather than the database layer. However, if you insist on using T-SQL, it's a simple piece of string manipulation. Look up CAST, CONCATENATE and RIGHT in Books Online.

John