Update Statement No working.

[Razor1]

I don'r write a lot of sql statements so I would appreciate help with this.

I need to update a colunm with the current value plus and .csv to the end of the contents in the column.

Example:
ARBatchFileName = R01234 (Currently)
After update it should be: ARBatchName = R01234.csv

Here is the code I used:
UPDATE Invoice
SET ARBatchFileName = ARBatchFileName + '.csv'
WHERE (((ARBatchFileName) Not Like '%.csv'));

The column ARBatchFileName now contains 'ARBatchFileName.csv'
Instaead of twhat was in the column originally.

Thanks in advance for any help.

Razor1

 

[markros]

The code you used seems to be correct.

Instead of UPDATE I suggest to first try select statement, e.g.

select ARBatchFileName, ARBatchFileName + '.csv'
from Invoice where ARBatchFileName NOT LIKE '%.csv'

If this works correctly, change select to your UPDATE.

PluralSight Learning Library