CAST and CONVERT are two functions that allow you to change the data type of a value or an expression in SQL. Both functions take a value or an expression as the first argument, and a target data ...

Assuming your using SQL Server 2000 (if not you could do something similar but using stored procedures)<BR><BR>I'd create a function and use that.