SELECT SUBSTRING(Column1,1,4) + SUBSTRING(Column1,4,3)  AS Col1
FROM MyTable
WHERE Col1 = 'MySearch'

SELECT SUBSTRING(Column1,3)  AS Col1
FROM MyTable
WHERE SUBSTRING(Column1,3) = 'MySearch'