Problem in Dynamic Where clause..

[Former Member]

Hello All,

I have a requirement in which i have to do a select statement where (Field1 = 'X') and (Field2 = 'A' or Field2 = 'B').

But if i write it directly,

select * from Ztable into table itab where Field1 = 'X' and Field2 = 'A' or Field2 = 'B'.

Then I am not getting the expected result.

instead i need something which tells the where clause to do OR operation first and then AND operation..

Any ideas ??

Thanks in advance.

Tatvagna Shah.

[Former Member]

Hello All,

I have a requirement in which i have to do a select statement where (Field1 = 'X') and (Field2 = 'A' or Field2 = 'B').

But if i write it directly,

select * from Ztable into table itab where Field1 = 'X' and Field2 = 'A' or Field2 = 'B'.

Then I am not getting the expected result.

instead i need something which tells the where clause to do OR operation first and then AND operation..

Any ideas ??

Thanks in advance.

Tatvagna Shah.

[Former Member]

Hi,

Please try this.

select * 
from Ztable 
into table itab 
where Field1 = 'X' and ( Field2 = 'A' or Field2 = 'B' ).

Regards,

Ferry Lianto

[Former Member]

Hi,

Actually...just got a hint at almost the same time you answered...!!

Still 10 points for you....Just coz, you were the only one to reply.

Thanks.

Tatvagna.

[Former Member]

Also, you must remember that parentheses and operators are keywords, and must therefore be preceded and followed by at least one space.