topic Re: select lowercase. in Application Development and Automation Discussions

select lowercase.

Former Member — Tue, 07 Jul 2009 17:43:38 GMT

Hi experts ,

i need to select a record from a table using the lower case statement as follows :

Data : wa_value type pa0006.

select single * from pa0006 into wa_value where lowercase (stras) = 'abcd'.

Stras is of type pad_stras .

so i want to get the result of in the table pa0006 the valoe of stras = 'AbCD' (abCd) ..etc.

This is not wirking in abap , so how to slove this problem ?

ps : transalte to lowercase /upper case doesnt help.

Thanks in advance.

Re: select lowercase.

former_member189420 — Tue, 07 Jul 2009 18:01:10 GMT

Hi,


> Hi experts ,
> 
>  i need to select a record from a table using the lower case statement as follows :
> 
> Data : wa_value type pa0006.
> 
> select single * from  pa0006 into wa_value where lowercase (stras) = 'abcd'.

Try the following.

select single * from  pa0006 into wa_value 
where (stras+1(1) = 'a' or 'A') and
            (stras+2(1) = 'b' or 'B') and
            (stras+3(1) = 'c' or 'C') and
            (stras+4(1) = 'd' or 'D').

Hope this helps. Let me know if it works.

Thanks & Regards,

Anand Patil

Re: select lowercase.

Former Member — Tue, 07 Jul 2009 18:02:16 GMT

Depending on your databse, you may be able to use native SQL to do this. It works in Oracle and DB6.

Rob

Re: select lowercase.

suresh_datti — Tue, 07 Jul 2009 18:46:51 GMT

What exactly you are trying to validate? PA0006 is the address infotype and maintained at the employee (pernr) level & can have more than one subtype. You cannot do a perfect select single statement on pa0006, so you can do your validation inside the select..endselect loop.

~Suresh

Re: select lowercase.

Former Member — Tue, 07 Jul 2009 20:05:08 GMT

The select i have in my question is just an example .

i try to select from a z-table with a condition using lowercase, to check if the a record exists with the same streetname, house number, postal code and city .

i know it working only with native sql , but our database is sql server.

Re: select lowercase.

suresh_datti — Tue, 07 Jul 2009 21:27:43 GMT

If it is a Z-table, have you looked at using the 'Lower Case' property at the domain level for the fields in question?

~Suresh