Wont be able to get sample data , but this is how the data looks like

Month_Year MyMonth MyYear Group A ...

Sure will do.

Thanks a lot.Made my day! Saved me a lot of work.

select datepart(mm, cast( Month_Year as datetime)) gives conversion error too

Yeah was about to inform , its varchar .Datepart not working

Will try. Thanks

That helped. Thanks

Thanks Sean and Luis.

Sean , I meant to say , I tried both options but did not work.

Well, Luis , the IN clause works great.

Wonderful, much more than I could ask for. Thanks a lot.

Great!. Works but then I get an error : Invalid length parameter passed to the left or Substring function

Thank you all for your help. Appreciate it.

No Worries.

I believe I forgot the second END which was causing the error.

Its Working now.. Thanks a lot!

Thanks for the response . But

Should we not add "When" after the 2nd and 3rd Case ?

Also , When I do so I get an error : Incorrect syntax...

No Worries , I figured it.

The join is the other way round:)

My Bad, I am using The LIKE Operator. ( Typo)

No Worries, Found a Link that helped.

LTRIM(LEFT(p.Delivery_Site, CHARINDEX(' ',p.Delivery_Site)))