Using SQL 2005. I have a field with dollar amounts but field type is VarChar. Need to convert to number to sum. What's the best way to do this or how can I sum a field type Varchar that has dollar amounts. Thank you, Davidfunction = cast
datatype = money
as in
declare @.c1 varchar(10), @.m1 money
select @.c1 = '123.45'
select @.m1 = cast(@.c1 as money)
select @.m1|||Thank you very much. Works great. David
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment