Re: SQL escape games
- From: Martin Klier <usn@xxxxxxxxx>
- To: Jared Still <jkstill@xxxxxxxxx>, William Robertson <william@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 31 Aug 2010 11:42:56 +0200
Hi,
it seems that I did not describe my problem understandable enough. So
let me rephrase it.
Clarification: The field in question does not contain a '/'.
Test statement:
======================
Select count(*)
From table
Where Mailordernocustomerupper Like '%GF/_2%' Escape '/'
And Warehousesiteid In (4)
And Status<99
And Clientid In (6);
======================
Result in SQL*Developer:
COUNT(*)
----------
6
Result in SQL*Plus:
COUNT(*)
----------
14
Where does the different behaviour come from?
Thanks in advance
Martin Klier
--
Usn's IT Blog for Linux, Oracle, Asterisk
http://www.usn-it.de
--
//www.freelists.org/webpage/oracle-l
Other related posts:
