% sign in format?
How would I go about inserting a % sign in format/formatex etc? I've tried % on it's own, ^%, %% but none of these work. I need to use it with SQL LIKE:
LIKE '%%s%' Currently I get a run time error 'String formatted incorrectly'. Stu |
Re: % sign in format?
Never mind. The problem was because I was using formatex to create my query string and then passing that variable onto SQL_PrepareQuery, which also uses format and the %'s already in the string were causing the error.
Stu |
Re: % sign in format?
To escape the % in format you need to do %%.
Code:
|
| All times are GMT -4. The time now is 21:30. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.