You can, but I wouldn't recommend it:
declare @STR as table( val varchar(20))
insert @STR select '12-FLA-2-02'
insert @STR select '12-FLA-2-12'
declare @update varchar(20)='11111'
select * from @STR
update @STR set val=replace(val,LEFT(val, CHARINDEX('-', val)-1) ,@update)
select * from @STR
Yes makes sense.Thanks for pointing that out..
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server