>That's not what I meant. Read up on creating views in SQL Server and making them updatable. You would be using this view instead of the table in your code then.
>
>I had several links when I first was reading your question, but I don't have them right now and don't want to start searching again.
Well, I do not want to update the table. I only want to update the result so I can ship that to a client.