Data type mismatch - use the Transact SQL 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 About Expressions in Queries.