topic Re: Query in Application Development and Automation Discussions

Query

Former Member — Wed, 13 Jun 2007 04:54:51 GMT

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 — Wed, 13 Jun 2007 04:56:20 GMT

give as LIKE 'Z%'

Former Member — Wed, 13 Jun 2007 04:56:24 GMT

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

regards

shiba dutta

Former Member — Wed, 13 Jun 2007 04:59:13 GMT

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 — Wed, 13 Jun 2007 05:00:17 GMT

Thanks it is working fine.

Former Member — Wed, 13 Jun 2007 05:01:03 GMT

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 — Wed, 13 Jun 2007 05:05:47 GMT

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