how can i convert this query result to date format (SQL-Server :  this for example :
concat (concat('201',(substring('A41020',2,1)),'-',(substring('B210906',6,2))

and the result is 2014-06.

what additional query I can use to change this string (2014-06) to date format automatically while I retrieve the data?

please help me.