Search:

Try it and see

To much there to read and analyze.

I still think you would be better calling a stored procedure rather than trying to do all that in one string.

Edit: one thing I do notice...

Would be better to create a stored procedure and execute it from VB

To answer your question you would have to build it like you do the one in the top example


strSQL="SELECT TOP 1 "...