topic Re: Functions in SQL query in Application Development and Automation Discussions

Functions in SQL query

Former Member — Tue, 24 Feb 2009 13:50:57 GMT

Hello Xperts,

I need to write a select query which will give me the length of the string value stored in the field.

At present I have to read all values from the table and then loop at each value into workarea to find length of each field.

Is there any alternative to this? I am querying a table with more than 300K records and I do not want to loop at 300K records to find the desired field.

Any help is highly appreciated.

Ashutosh

Re: Functions in SQL query

former_member156446 — Tue, 24 Feb 2009 13:57:20 GMT

I guess loop is mandatory to check each field....

loop at itab assigning <fs>.

assign components sy-index of structure <fs> to <fs_fied>.

find string length...

endloop.

Re: Functions in SQL query

Former Member — Tue, 24 Feb 2009 15:12:32 GMT

I found the workaround..

Select ......... where column not like '__________'.

This gives me the field which has lenght more than or less than 10 characters.

-Ashutosh