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