i have startdate coloumn in yyyyMMdd formate as varchar datatype and maglenth i need sql query to seprate month and year and if maglength is 1 then show subscribedas magtype ...