Update problem

[nollieflip]

I need to update a column that I did not originally populate on the first pass of my DTS script.

In my DTS I needed to combine our accountid's and account locations into one string. The problem now is how to write a update statement and the source data has the id's and locations still seperated...

Here is what I have, SQL tells mell "Invalid column name '0000'" (I needed to pad the right side of our account strings with 4 0's)

UPDATE BuildAccount
SET EmailAddress1 = (SELECT EmailStandards.EmailStandard
FROM EmailStandards WHERE BuildAccount.AccountNumber = EmailStandards.Account & right("0000" & EmailStandards.Location,4))

 

[dmhirsch]

Replacing your ampersands with plus signs should work.

 

[JayKusch]

Need to change the " to ' also.

Thanks

J. Kusch

 

[nollieflip]

Worked perfect. Thanks!