Select by the first character

[Former Member]

Hi.

I want to maka a select of table ekko when the field inco1 begin by 'F'.

How i can do it.

Thanks.

[Former Member]

select * from ekko where inco1 like 'F%'.

endselect.

reward points if its helpful

[Former Member]

Hi Andres ,

You can use LIKE in the select statement.

e.g.

select ....

from

where <f1> like 'F%'.

Regards

Arun

[former_member784222]

Hi,

You can use in your where condition 'INCO1 LIKE 'F%'.

Thanks and regards,

S. Chandra Mouli.

[Former Member]

Hi,

Select * from EKKO into table IT_EKKO where INCO1 = 'F%'.

Regards

Sudheer

[Former Member]

select ..from ekko where inco1 like 'F%'.

Message was edited by:

Chandrasekhar Jagarlamudi

[Former Member]

Hi,

select * 
  from ekko 
  into table itab
 where inco1 like 'F%'.

The use of the wildcard characters "_" and "%" corresponds to the standard of SQL. In the rest of ABAP, the wildcard characters "+" and "*" are used in similar logical expressions, in particular when selection tables are used.

You should not use patterns that are closed by wildcard characters to search for closing blanks.

The semantics of searches of this type are dependent on the database system that is used and in general do not lead to the desired result.

Hope this helps.

Regards,

Richa

[sreeramkumar_madisetty]

Hi

Use like:

select ....

from

where <f1> like 'F%'.

Regards,

Sree

[Former Member]

Hi

We can use wild character but it will be having a performance issue. If possible declare a range statement and pass the value in low as F*. It will work like your select option.

Hope will be helpful.

regards

thiru

[Former Member]

Hi,

Write the select statement as:

SELECT (db name) INTO TABLE (internal table name) WHERE (fieldname) LIKE 'F%'.

Regards,

Balakrishna.N