topic In Where clause String comparison in Application Development and Automation Discussions

In Where clause String comparison

Former Member — Tue, 18 Sep 2007 03:09:35 GMT

Request for help in regard to the select statement where clause Ex:(Select single name into v_name from XYZ where text = string).

String and text data types are same.

String will have only 3 char and text will have 40 char of length.

Out of 40 char I would like the where clause to search any of the 3 char and fetch the record.

Hope my question is clear and can expect help on this regards,

Thanks,

Azhar.

Former Member — Tue, 18 Sep 2007 03:28:26 GMT

Select single name into v_name from XYZ where text LIKE string.

Former Member — Tue, 18 Sep 2007 12:44:37 GMT

I have tried with like in where clause, it does not work my scenario.

I will not be comparing the complete string, only single char...in the table field.

Former Member — Tue, 18 Sep 2007 13:07:59 GMT

Hello Azhar,

you can use % with the like in the where condition.

example: string = 'chandra' vendor name.

select * from lfa1 into table it_lfa1 where name1 like cha% .

i think this help you.

reward if useful,

Regards,

Phani.

Former Member — Tue, 18 Sep 2007 17:16:47 GMT

Hi Phani,

The string which will be in where clause will be dynamic.

I have tried %string%, String, +String, +String_.

For ABAP we should use *, +, _ only.

I have gone through the SAP Help to get the above info...

But my requirement will not fit with this options.

Regards,

Azhar.