>>Dunno what you mean - but you wouldn't need TRIM
>
>I would have to do more tests on this one.


You may need to adjust the collating sequence to CaseInsensitive

declare @TmpPrefix table
(	Prefix	varchar(8),
	Tag		varchar(8)
)

insert into @TmpPrefix (Prefix, Tag) values ('AB', 'CM111')
insert into @TmpPrefix (Prefix, Tag) values ('CD', 'CM111')

declare @TempTable table
(	Name	varchar(20)
)
insert into @TempTable (Name) values ('Abertimer')

select * 
	from @TmpPrefix
		join @TempTable on (Name like Prefix + '%')