Multi-row modification is not supported ???

[WMitchellCPQ]

Im trying the SQL following code..

UPDATE    [Order]
SET              InvoiceTo = RTRIM(InvoiceTo)
WHERE     (RIGHT(InvoiceTo, 1) = ' ')

However im getting a multirow modification error when i try and run it against my order table. Order is a really big table..

I hate working on Holidays

 

[dbomrrsm]

UPDATE table_name
SET    InvoiceTo = RTRIM(InvoiceTo)
WHERE  RIGHT(InvoiceTo, 1) = ' '

Should work

[blue]DBomrrsm[/blue]