I think what you want is the TOP clause in your SQL SELECT:
SQL TOP 1 * FROM MyTable ORDER BY MyColumn
>Hello,
>I am performing a SQL call in my VB.NET app where I grab the records sorted by date and put them in my dataset. What I want to do, however, is to grab 1 records (the most recent) and not the others. I am sure this is probably a simple questions, but I am not finding the answer. Thanks!
>
>MAC
Chris McCandless
Red Sky Software