Print Thread
query by example: like %
#14043 05/04/04 12:29 PM
Joined: Jan 2003
Posts: 46
J
Member
OP Offline
Member
J
Joined: Jan 2003
Posts: 46
I have different behaviour with query by example when I enter A in a varchar2 column.

On some machines it generates :deptname like 'A%'
On another: deptname like 'A'
even sometimes:deptname = 'A'

What is the option to control that ?

Re: query by example: like %
#14044 05/04/04 10:13 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
This behavior is affected by the "Query By Example" preferences (Tools > Preferences > SQL Window tab page). The "Automatic contains" option controls whether A is converted to %A%.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.031s Queries: 13 (0.010s) Memory: 2.4982 MB (Peak: 3.0426 MB) Data Comp: Off Server Time: 2024-05-18 10:48:57 UTC
Valid HTML 5 and Valid CSS