Thank you all for the help.

Jeff, I read the Helpful Links that is posted and will follow the directions with future posts.

Thank you all again,
Tony

Hi Sergiy,

I will look into this.

Thank you,
Tony

Thank you Drew for the code...It works great with the test data that was inserted.
When I tried the code to the table that the data is in, it truncated...

Thank you for the query. This works only when there is one item in the column. In my example utilizing yours,

Data0 [2], Data1 [2602], Data2 [130]

will...

Worked beautifully. I like simplicity.

Thank you both very much.

Tony

Thank you both.

I will try your suggestions and let you know.

Tony

Hi...

I am looking to pull the one order with the next maximum date.

I am running a separate program that has this sql code embedded.

It passes variables to the code. I...

Andre...thank you for replying!

I have a few orders in the table that are sorted by Date desc.

In the table the first two orders in the table are:

1. Glucose ...