03-08-2024 4:03 PM
Hi,
I have a below select statement in ABAP
SELECT SINGLE A, B ,C
FROM lt_tab INTO @DATA(tab1) WHERE B <> C.
But the Column C is having ALPHA conversion with Leading 0's. Hence, Select statement is not working as expected. Could you please help me how we can Remove leading zeros in ABAP select statement at where condition.
Regards,
Praveen.
03-08-2024 4:22 PM - edited 03-11-2024 2:45 PM
Did you try to use sql string functions in the where clause?
03-08-2024 5:58 PM
SELECT is working as expected (it never considers the conversion routines, including ALPHA), but you expect to find a way to simulate the ALPHA conversion routine via an SQL function. As you may know, the available SQL functions highly depend on the ABAP version you are using, so you should indicate your ABAP version.