Re: Dashes in sql statement when using paramters causes HY010 sql error
Hi Oscar,
The dash in the parameter does not seem to be the problem. What is the error that you are getting?
When I tried in either 20.1 or 19.1 (using driver build 6.3.0.25) I do not get any errors. I used MSSQL 2019 and our Customer table from Order Entry. The attached program ran without a problem. Can you try this to see what you get?
Where non-alphanumeric character must be used in the search criteria (primarily the dash - character), use the Transact-SQL LIKE clause instead of the FULLTEXT or CONTAINS predicates.
Last edited by Marcia Booth; 10-Jun-2022 at 03:27 PM.