Skip to Content
0
Former Member
Dec 06, 2006 at 09:40 PM

NULL vs INITIAL

840 Views

Hi all.

Here is my performance dilemma.

Is there any difference between these two lines of code?

SELECT * FROM /abc/def INTO TABLE lt_abc WHERE my_var IS NOT NULL.

or

SELECT * FROM /abc/def INTO TABLE lt_abc WHERE my_var NE ''.

I get a performance error if NULL is used. Would second line be a good alternative?

Thank you.