yep...see my first post.
V
Valeri
@Valeri
0
Reputation
4
Posts
29
Profile views
0
Followers
0
Following
Best posts made by Valeri
This user hasn't posted anything yet.
Latest posts made by Valeri
-
RE: Oracle and NULL
Actually...i tried to do this:
SELECT * FROM SM_STPD_TB
WHERE SM_STPD_CD != 'XYZ'
AND SM_STPD_CD IS NULL
and it didn't even bring back the NULL values..."no rows returned".
Yay Oracle! -
RE: Oracle and NULL
Actually you need to do this:
SELECT * FROM SM_STPD_TB
WHERE SM_STPD_CD != 'XYZ'
OR SM_STPD_CD IS NULL
otherwise it will only return values that are not 'XYZ' AND NULL so it will only return the NULL values.