Current Position:Home > Exclude "*" in Like operator

Exclude "*" in Like operator

Update:10-11Source: network consolidation
Advertisement
Hi All,
I am trying to use like operator for an output data which has "*" appended at the end.
For example, following is the Place_ID which i have data in a table
12190101*
12349021
12347284
12598992*
When i provide search criteria as "1234" in my application, my query is making the condition as
Place_ID Like "1234%"
But unfortunately it is giving 4 rows as output which is not considering the values which is appended with '*".
I tried making use of the following, but still this is not working.
Place_ID Like "1234%" ESCAPE '*'
Can someone suggest me where i am doing wrong.
Thanks,
Prakash

The Best Answer

Advertisement
Prakash wrote:
But unfortunately it is giving 4 rows as output which is not considering the values which is appended with '*".It is not clear what output you expect. But one thing is for sure: condition Place_ID Like 11234%' can't return 4 rows:
{code}
with data as(
select '12190101*' place_id from dual union all
select '12349021' from dual union all
select '12347284' from dual union all
select '12598992*' from dual
select place_id
from data
where place_id like '1234%'
PLACE_ID
12349021
12347284
SQL>
{code}
So post desired results.
SY.
  • Exclude "*" in Like operator Update:10-11

    Hi All, I am trying to use like operator for an output data which has "*" appended at the end. For example, following is the Place_ID which i have data in a table 12190101* 12349021 12347284 12598992* When i provide search criteria as "1234

  • Ignore particualr DML operations, like delete Update:11-30

    User wants to copy all dml changes on sources tables, EXCEPT DELETE, can we set such rules for capture, or propogration, or apply processes? Thanks.See the metalink note: How To Exclude Specific DML Operations From The Capture Process When Using Stre

  • DDL EXCLUDE ALL in GoldenGate Update:11-30

    Looks like this is a new feature but doesn't have enough documentation. Does anyone know what it really is for? What we want to do is not use GoldenGate for DDL replication in biderctional setup but do it manually in controlled fashion. In streams it

  • Excluding methods for servicegen task Update:11-30

    Is there any way to exclude selected methods from being included in the automatic type generation for the <servicegen> ant task? I have a Stateless EJB I would like to use. I only need methods which return the built-in types, but the bean includes s

  • Production order status report Update:10-11

    I want a report regarding the Work center reporting mentioned below. 4 operations in the Routing for the material Operation 10     1111(Work center) Operation 20     2222(Work center) Operation 30     3333(Work center) Operation 40     4444(Work cent

  • REPORT  ZRSDRC_CUBE_DATA_GET. Update:10-11

    Hi SDN Community, We have written the following program which access the FM RSDRC_CUBE_DATA_GET. The only thing i am unsure of at the moment is how to declare a STANDARD TABLE for this. DATA E_CUBE_DATA LIKE STANDARD TABLE. I have only taken a first

  • BlackBerry PlayBook and Internet Explorer? Update:10-11

    I am a small business owner and Mac user. My business, however, uses a website that works only with Internet Explorer. In the past I have needed to have a small notebook PC in order to access the site and it is time to get a new computer.  I really w

  • Png files not uploading Update:11-30

    I'm using a couple of png files on a page. If I upload the page and choose to upload the dependent files - which would include the png files - the png files never upload to the server. Jpg and gif files get uploaded fine, but not png. When I view the

  • Annoying messages bug when using mass storage to s... Update:11-30

    As you all well know the c: drive on n97 is quite small. I have about +2000 messages on my phone and I use the 32gb mass storage to store all of my emails and sms's.  It works ok untill I connect my phone to pc using mass storage mode. The first thin

  • PPM .vs. PDS Update:11-30

    Hi all... Can you say me the differences between the PPM and PDS?... Can you say me the functionalities covered by PPM and PDS?... Thanks in advance for your help. Regards Angel Message was edited by:         Angel GonzalezCheck out Note 1079959 - PD