Question:
How do I compare two values when one value(data type) is char and the other is an integer?

Answer:
For this you can use the CONVERT function. Since you can’t convert character data to numbers, you’ll have to convert the integer column to character. Assuming you have a table called TestTable with two columns:

IntCol intCharCol char(10)with these valuesIntCol   CharCol------   -------1         12         23         xyz4         5

You can use this query to SELECT rows based on a comparison:

SELECT *FROM TestTableWHERE CONVERT(char(10), IntCol) = CharColIntCol      CharCol    ----------- ---------- 1           1         2           2