Data type mismatch - use the CONVERT function.

Visual Database Tools

Visual Database Tools

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 Using Expressions in Queries.