topic Re: select statement query... ! in Application Development and Automation Discussions

select statement query... !

naveenvishal — Sat, 24 Nov 2007 04:43:54 GMT

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 — Sat, 24 Nov 2007 04:45:10 GMT

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 — Sat, 24 Nov 2007 04:46:29 GMT

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 — Sat, 24 Nov 2007 04:53:33 GMT

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 — Sat, 24 Nov 2007 05:00:24 GMT

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 — Sat, 24 Nov 2007 05:05:54 GMT

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

Thanx,

Naveen VIshal

naimesh_patel — Sat, 24 Nov 2007 05:08:00 GMT

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

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

Regards,

Naimesh Patel