I have an issue with cast, when i am converting nvarchar which is a number to float or money, i get the result multiplied by 100 in some cases and in some cases it is fine.
Ex: select cast ( [qty] as float), cast([price] as money)
qty and price are both nvarchar(50)
if qty - 10.00 price 200.00 (before conversion),
its qty - 1000 and price is 20000 (after conversion)
Please let me know if there is any issue using cast.
Thanks in advance.
View Complete Post