InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 21:00:46 GMT20http://www.sqlservercentral.com/Forums/Topic976278-338-1.aspxAll data types in the coalesce function must be the same.Try converting the ProductID into a varchar which has a length equal to the larger of productclass and productcolor.e.g.[code]Coalesce (ProductClass,ProductColor,convert(varhchar(100), ProductID))[/code][quote][b]Kirman (8/27/2010)[/b][hr]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[/quote]Fri, 27 Aug 2010 05:22:31 GMTSQLZhttp://www.sqlservercentral.com/Forums/Topic976278-338-1.aspxHi,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.ThanksFri, 27 Aug 2010 04:57:57 GMTKirman