[V4RB] sql question

[Dave Parizek]

>

I have a single table query where I wish to set the contents of 1 
field in the table = the corresponding contents in another field. 
Below, Sku and Location are fields in table Item.

update Item set Sku = Location

When I do this all the values in the Sku field become the literal 
string "Location" instead of the values from Item.Location.

Do I have the syntax wrong?

--Dave

-- 
_______________________________________________
Dave Parizek
Bookseller
Dave at Parizek.com