Query

[Former Member]

Hi,

I have a simple doubt plz resolve.

I need to select all from table called V_CMP_JOIN and put in another internal table where need to include 2 conditions

One is objvers it should be ‘A’ and that’s working fine.

And one more condition is :- one more field called compid I need to display whose compid starts with Z or Y (custom queries).

so i tried like this.

Select * from V_CMP_JOIN into table it_qryobj and objvers = 'A' and compid like ‘%Z’.

But it is not displaying all start with Z …am I using correct syantax?

Thanks,

Vijaya.

[Former Member]

give as LIKE 'Z%'

[Former Member]

Select * from V_CMP_JOIN into table it_qryobj and objvers = 'A' and compid like ‘Z%’.

regards

shiba dutta

[Former Member]

hi

try this...

Select * from V_CMP_JOIN into table it_qryobj where objvers = 'A' and compid like ‘Z%’.

Message was edited by:

Premalatha G

[Former Member]

Thanks it is working fine.

[Former Member]

hi vijaya,

i think it should be

Select * from V_CMP_JOIN into table it_qryobj and objvers = 'A' and compid like ‘Z%’.

Reward points if helpful

Cheers,

PRash

[Former Member]

Hello Vijaya Salagundi,

<b>compid like ‘%Z’</b> means it will look for those whose compid ends with charcter 'Z'.

For your requirement use <b>compid like ‘Z%’</b>, this will look for those whose compid's starts with 'Z'.

Reward points if helpful

Regards

--

Sasidhar Reddy Matli