CAST

Changes the type of a specified value

DECLARE @SomeValue NVARCHAR(255)

SET @SomeValue = '1234'

SELECT *
FROM SchemaName.TableName
WHERE CAST(colName AS NVARCHAR(255)) = @SomeValue