How select a field with null (?) in the sql editor?

Posted by carlos@lux.mx on 24-Mar-2014 14:54

Hi, I´m using the sql editor in the Development Studio Version 11.03, and I want make a "Select" the records where have a field with null value... (in a for each will be = ?..)

Thanks!

OpenEdge Development - Forum

Posted by Youssif Shanshiry on 24-Mar-2014 18:24

The following query will return all the order data for the records with NULL shipdate field value:

SELECT * FROM PUB.Order WHERE ShipDate IS NULL

All Replies

Posted by Youssif Shanshiry on 24-Mar-2014 18:24

The following query will return all the order data for the records with NULL shipdate field value:

SELECT * FROM PUB.Order WHERE ShipDate IS NULL

Posted by carlos@lux.mx on 24-Mar-2014 18:51

Thanks!! you save my day!!

This thread is closed