RuGroup will be containing like this...
I've checked MA and the length. How can I check if 3rd digit is a number? cuz if value is stored as MAS, I need to display that. Please let me know how to use EndsWith property or something else in this..
getRetailUgrp = (From retailUnitGrp In RetailUnits Where Not (retailUnitGrp.RuGroupName.ToString.StartsWith("MA") And retailUnitGrp.RuGroupName.ToString.Length = 3)).ToList()