SELECT LEFT(ITEM_NM,CHARINDEX('.',ITEM_NM)) FROM ITEMS
create table #t(a varchar(20)) insert #t(a) select 'B.0123' union select 'KCFL.MD04-WER.1123'select substring(a,1,charindex('.',a) -1) as new_string from #t/* B KCFL*/
SELECT LEFT(ITEM_NM,CHARINDEX('.',@item)) FROM ITEMS
SELECT LEFT(ITEM_NM,CHARINDEX('.',ITEM_NM)-1) FROM ITEMS
SELECT LEFT(ITEM_NM,CHARINDEX('.',ITEM_NM)-1) FROM ITEMS
select substring(item_nm,1,(charindex('.',item_nm)-1)) from items
FROM ITEMS
insert #t(a)
select 'B.0123'
union select 'KCFL.MD04-WER.1123'select substring(a,1,charindex('.',a) -1) as new_string from #t/*
B
KCFL*/
FROM ITEMS
FROM ITEMS
SELECT LEFT(ITEM_NM,CHARINDEX('.',ITEM_NM)-1)
FROM ITEMS
select substring(item_nm,1,(charindex('.',item_nm)-1)) from items