How do I compare two values when one value(data type) is char and the other is an integer?
use the CONVERT Function.