Sometimes you find priceless little nuggets of knowledge precisely when you aren't looking for them. Perusing Sql Server books on line I stumbled across the STR() funtion which basically converts any numeric data into a character string. For years I have been typing cast(<someNumericColumn> as varchar) when STR(someNumericColumn) would have sufficed.... Doh!