Kieth,
I think something like select * From table Where Instr(SOMEFIELD,"%") > 0 would work.
r
On Mon, 21 Jun 2004 10:59:42 +0100, Campbell, Keith A <[EMAIL PROTECTED]> wrote:
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
--
Robert Crossley Agtrix P/L 9 Short St PO Box 63 New Brighton 2483 Far Southern Queensland AUSTRALIA
153.549004 E 28.517344 S
P: 02 6680 1309 F: New Connection M: 0419 718 642 E: [EMAIL PROTECTED] W: www.agtrix.com W: www.wotzhere.com
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12314
