Hi,
Here is the statement I'm trying to run....

declare @A varchar(5)
select @A='123'
select @A=(select convert(money,@A))
select @A

This is the error message I get:
Implicit conversion from data type money to varchar is not allowed. Use the CONVERT function to run this query.

Does anyone know what should I change in the query to make it work?

Thank you very much,
Anastasia.