Coalesce (ProductClass,ProductColor,convert(varhchar(100), ProductID))

Kirman (8/27/2010)

---

Hi,

I have the following Coalesce Query

Coalesce (ProductClass,ProductColor,ProductID)

ProductClass and ProductColor are of the same datatype varchar , but the ProductID is of the Integer Data Type.

When I execute the query it gives the Data Conversion Error
i.e. Cannot Convert from int to character data type.

Can anyone help me in resolving the same.

And also :

Where exactly one can use the Coalesce Function.

Thanks