I have a SQL ODBC connection using MS Query in Excel. I use a parameter to define a sql command in MS Query but the wildcard is just not working.
The command in MS Query is (TABLE.COLUMN Like '%'+?+'%'). ? refers to the parameter.
I put C177 in the parameter and it returns info but not ALL the info. I have fields with C175C176C177 which the query doesn't return; it will only return fields that have ONLY C177 in them. The SQL query on the SQL server works fine but when I use the exact same language using the parameter wildcard in MS query it breaks it. If I use an exact choice in MS query like C177 it returns properly, it's only when I use the parameter "?" for some reason.
Help please, this is driving me nuts!
Bookmarks