Convert YYYYMM to MMMYY

Use the DATENAME & SUBSTRING functions, like this:

declare @str nvarchar(50) = '201604'

select UPPER(left(datename(mm,cast(@str+'01' as date)),3))+substring(@str,3,2) --APR16