>Saying OleDb Provider and I know you're doing Vb.Net this question is really meant how to do from VB.Net, right? Otherwise doing that with a single SQL (though might be possible with VFP's-I don't know) if ever could be done I think would be slow.
Thanks for the sample, but you might have seen in the other message that I used the route of adding an additional field in Style.dbf for that which is maintained by the robot. This gives me maximum performance at run time.