topic Re: SQL select in Application Development and Automation Discussions

SQL select

saurabh_chaturvedi — Wed, 03 Apr 2013 09:56:13 GMT

Hello Experts,

I have table where one of the columns is called COL1.

Suppose this table has just one record where the column COL1 has the value 56006*.

I want to select the above record even when I look up this table for records with COL1 value = 560068.

How can I write such a query?

Thanks & Regards,

Saurabh

Re: SQL select

Azeemquadri — Wed, 03 Apr 2013 10:06:14 GMT

In select you can use the like operator and the % symbol.

select

col1 from itab1 where col1 like '56006%'.

Re: SQL select

RaymondGiuseppi — Wed, 03 Apr 2013 10:07:39 GMT

Alas OPEN-SQL don't allow a syntax like "dobj LIKE field+%", so you should programmatically convert your single value in a list of values, a range like

I EQ 560068
I EQ 56006
I EQ 5600
I EQ 560
I EQ 56
I EQ 5

Regards,

Raymond

Re: SQL select

Former Member — Thu, 04 Apr 2013 09:15:34 GMT

Hi,

I think that this example is useful for you

   REPORT z_example_abap.

TABLES vbak.

DATA: BEGIN OF tb_vbak OCCURS 0,
        vbeln LIKE vbak-vbeln,
        netwr LIKE vbak-netwr,
       END OF tb_vbak.

START-OF-SELECTION.
REFRESH tb_vbak.
CLEAR tb_vbak.
SELECT vbeln netwr FROM vbak
    INTO TABLE tb_vbak
         WHERE vbeln LIKE '%178%'.

DESCRIBE TABLE tb_vbak LINES sy-tfill.

END-OF-SELECTION.

Regards

Ivan

Re: SQL select

Former Member — Thu, 04 Apr 2013 12:38:18 GMT

This message was moderated.

Re: SQL select

Former Member — Thu, 04 Apr 2013 12:46:53 GMT

SELECT * FROM table name INTO TABLE gt_itab WHERE COL1 LIKE '560006%'.

Re: SQL select

matt — Thu, 04 Apr 2013 13:32:49 GMT

It seems you're the only who spotted that the wildcard is a value the table!

Re: SQL select

RaymondGiuseppi — Thu, 04 Apr 2013 13:48:53 GMT

Yes, alas , as most people see what they expect to see, not what is written. Moreover, in this case the question would have been too basic and would have justified a "Report abuse" .

It looks like a Customizing table with wildcard and the program look for items that can be applied to a value.

Regards,

Raymond