I have the following Coalesce Query
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.