SELECT * FROM table WHERE YOUR_INTEGER_VALUE::varchar = 'string'; # or SELECT * FROM table WHERE cast(YOUR_INTEGER_VALUE as varchar) = 'string';