>I guessed when you originally posted, that you didn't have a working solution. You asked a question, we're given an answer, threw out the answer and went your own way. If you don't want to discuss the options, don't ask the question.

I am thinking that for the next part of this method I am converting from VFP into C# I do need to create two stored procedures.