CONVERT

CONVERT(VARCHAR(100), @SomeValue, 101)
-- Param1 - what you want to convert to
-- Param2 - the value you want to convert
-- Param3 - how you want to convert it