To do that, you would have to bring back the values individually, as numerics. It would probably be best to define the format as part of the select query, as you have done - you can't convert a series of number concatanated together with dollar signs and spaces back to a number.




Reply With Quote