topic Does Open SQL support if statement in Application Development and Automation Discussions

Does Open SQL support if statement

Former Member — Tue, 20 Jul 2010 16:14:05 GMT

Hi all

Wanted to ask how to or is it possible to include if-statement or case in a ABAP Open SQL

example

SELECT IF(NAME = '' , 'UNKNOWN', NAME ) FROM TABLE1 order by NAME ASCENDING.

Because I am trying to sort the data and the null value should be the last record to be seen.

Former Member — Tue, 20 Jul 2010 17:26:00 GMT

It is not possible to include if-statement or case in Abap open sql.

Inorder to get the null value as last record sort the table with key as field which as null values.

Thanks!!

Jelena_Perfiljeva — Tue, 20 Jul 2010 20:31:53 GMT

More proper way to do this in ABAP is IMHO to use SELECT ... WHERE into an internal table and then sort the table (SORT).