Data type mismatch - use the CONVERT function.

To work with different data types in a single expression, you need to convert to the same data type. One of the data types must be converted before you can continue.

For more information, see Data Type Conversion (Database Engine).

Community Additions