topic Re: comparing strings while executing a select statement in Application Development and Automation Discussions

comparing strings while executing a select statement

Former Member — Fri, 18 Jan 2008 13:52:58 GMT

hi,

i need to compare select the rows from table dd02t into the internal table li_tabdef where dd02-ddtext contains the string s_string(taken as a parameter)

i can't write the where clause as

*where dd02t-ddlanguage CS s_string* since CS is not a valid comparison operator. i need to compare the value of sy-fdpos.

can you please help me with the select statement

Re: comparing strings while executing a select statement

Former Member — Fri, 18 Jan 2008 13:55:00 GMT

HI,

You have use like 'ABC%' in where condition, like will work for wild card search not CS. If you want to search for a string which starts with ABC.

Thanks,

Sri,

Edited by: Sriram Ponna on Jan 18, 2008 7:25 PM

Re: comparing strings while executing a select statement

Former Member — Fri, 18 Jan 2008 14:02:43 GMT

the string is entered by the user. it is stored as a parameter s_string.

i need to use s_string for comparison.

Re: comparing strings while executing a select statement

Former Member — Fri, 18 Jan 2008 14:03:04 GMT

Hello,

Use like.

COncatenate S_STRING '%' INTO S_STRING.

where dd02t-ddlanguage LIKEs_string

Vasanth

Re: comparing strings while executing a select statement

Former Member — Fri, 18 Jan 2008 14:06:02 GMT

refer this

data : begin of itab occurs 0,

pernr like pa0001-pernr,

end of itab.

data : a type string.

a = '123'.

concatenate '%' a '%' into a.

select pernr from pa0001 into table itab where pernr like a and begda le sy-datum and endda ge sy-datum.

if sy-subrc = 0.

sort itab by pernr.

loop at itab.

write 😕 itab-pernr.

endloop.

endif.

now u get all pernrs containing 123......

Re: comparing strings while executing a select statement

RaymondGiuseppi — Fri, 18 Jan 2008 14:11:10 GMT

Define a field of the same type as the database field. CONCATENATE '%' parameter string and '%' into this field and use a database-field LIKE work-field in the SELECT statement.

Regards