Wiki Home

SQL Querywithvariable

Namespace: WIN_COM_API

I am writing a report using SQLEXEC to query several tables using the LIKE operator and am curious of the correct syntax to build the expression that will be passed. I currently have the following code as the "end" of my query. What is the correct syntax to pass to MS SQL Server?

LIKE %' & lc_ponum & '%

Any help is appreciated,

( Topic last updated: 2005.10.20 12:36:06 PM )