Does Open SQL support if statement

[Former Member]

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]

Hi

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]

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