>I am using 2.6, although I have 7.0(it's a migrataion thing).
>My question:
>Using the sql select statement, is there any way to write to the results, and update the database?
>example
>I have 1000 different locations, with several customers for each location. I want to tag 1 record for each location.
>There are several ways to do this, but I was hoping to discover a way to write directly to the data that meets the criterea. Any help?

Would yu elaborate it more and in which version (2.6) ?
Cetin