Home Forums SQL Server 7,2000 T-SQL Need to append a character onto end of data in a column RE: Need to append a character onto end of data in a column

  • April 22, 2005 at 7:13 am

    #554336

    Okay - to cover every realm of possibility :

    UPDATE TableName
SET SupplyName = LTRIM(RTRIM(SupplyName)) + '@'
WHERE RIGHT(SupplyName,1)  '@'
AND LEN(SupplyName) < 32

    Now, is there anything else we forgot about this simple update query?



    ----------------
    Jim P.

    A little bit of this and a little byte of that can cause bloatware.