select statement query... !

[naveenvishal]

im giving the select stmt as:

select ..... where name like 'D%'.

i want to eleminate caps lock defferentaion, so that all records with 'D' or with 'd' will be selected.

i want to include that in SINGLE LIKE only, not like this:

select ..... where name like 'D%' or name like 'd%'.

-

---

Kindly suggest if can b achieved.

Thanx,

Naveen VIshal

[naimesh_patel]

Yes it could be achieved as you have decided.

select ..... where name like 'D%' or name like 'd%'.

Like:

DATA: l_maktx TYPE maktx.

SELECT SINGLE maktx
 INTO l_maktx
 FROM makt
 WHERE ( maktx LIKE 'D%'
 OR maktx LIKE 'd%' ).

Regards,

Naimesh Patel

Message was edited by:

Naimesh Patel

[Former Member]

Hi Naveen,

I think If you keep 'D%' in your where clause it will consider both 'D%' & 'd%', need not to specify seperately.

Regards,

Satish

[naveenvishal]

can anything like this can be done, as in the case of Contains Pattern (CP) it is done like '#D#%'.

can u suggest for the single like stmt.

[naimesh_patel]

You can do it like this:

Where Field1 like '%D%'

But it will bring on the data where Field1 contains the D.. no matter in which place weather 1st or 4th or lat.

Regards,

Naimesh Patel

[naveenvishal]

yaar, what about the capital letter avoidance condtion..i need both 'D' as well as 'd'..

Thanx,

Naveen VIshal

[naimesh_patel]

For D and d you have to use it like this:

Where ( Field1 like '%D%' or field1 like '%d' ).

Regards,

Naimesh Patel