Home Forums SQL Server 2008 SQL Server Newbies Update Part of a SQL field with charindex RE: Update Part of a SQL field with charindex

  • June 24, 2014 at 2:04 am

    #1724247

    Sachin Nandanwar (6/24/2014)

    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

    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

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden