Does this help get you in the right direction?

declare @ TestStr varchar(32); -- to get this to post, I added a space between @ and TestStr, remove that space

set @TestStr = 'SC*101D*05';

select @TestStr = left(@TestStr, len(@TestStr) - 3);

select @TestStr;