• You can use REPLACE function as well.

    declare @str as table( val varchar(20))

    insert @str

    select '12-FLA-2-02'

    declare @update varchar(20)='11111'

    select * from @str

    update @str set val=replace(val,LEFT(val, CHARINDEX('-', val)-1) ,@update)

    select * from @str

    --------------------------------------------------------------------------------------------------
    I am just an another naive wannabe DBA trying to learn SQL Server