Select Substring(xx,1,2) from TABLE

select left(xx,2) from TABLE