Hi All, How do you escape special characters in a query within MapInfo? E.g. How would I select all records where a field contained the percent symbol? I believe that in standard SQL you can specify an escape character to use with each query, e.g.
SELECT * FROM SOME_TABLE WHERE SOME_FIELD LIKE '%20X%%' ESCAPE 'X'; to select all records containing 20%. This doesn't seem to work in MI. TIA, Keith This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12313
