topic Re: using substring in sql where condition in Application Development and Automation Discussions

using substring in sql where condition

Former Member — Fri, 21 Nov 2008 10:39:35 GMT

Hello,

I want to write an sql select similar to this one:

select * into wa from dbtab where substr(dbtab~field,2,4) = variable.

where variable is type c length 4.

I know that in various SQL there is a substr function but I can't find a similar one for the SQL used by ABAP...

Thanks.

Former Member — Fri, 21 Nov 2008 10:42:30 GMT

Hi,

you can wildcard text like

select * from dbtab where feild1 = '%like%'

regards

Ramchander Rao.K

Former Member — Fri, 21 Nov 2008 10:44:41 GMT

Yes, but this works for static texts, I want something that will work using a variable instead a static text.

Thank you.

ThomasZloch — Fri, 21 Nov 2008 10:46:57 GMT

Not available in Open SQL, try WHERE field LIKE '__text%' for your example to search for occurrence of "text" in positions 3 to 6 of the column.

Thomas

P.S. you can build the search string using your variable contents.

Former Member — Fri, 21 Nov 2008 13:27:59 GMT

if the contents in the table dbtab are only few , you can do the following.

select all the entries from the table into an internal table.

loop at the internal table checking for the required condition on the field.

this would reduce the burden on the database .