Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and ...

Easily create SQL queries and execute them on a database. For an example on how to use this library with data objects, see the VBA-Drupal-Library. For other examples on using the library, refer to the ...

VBA will use strLastName as a literal string and continue. If you were searching the LastName field, the query would return no records (as it’s unlikely to find a last name entry of strLastName).