[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Working with Null values of database in SQR



Parijat,

> I need to select rows from a table using begin-select based on a
> criteria that one particular column has a null value. How can I do that?

begin-select
my_column_1 (1,1)
from my_table
where my_column_2 is null
end-select

Ray
----------------------------------------------------------------------
Ray Ontko       |  Ray Ontko & Co  |  "Time for a new signature line."
rayo@ontko.com  |  Richmond, In    |  See us at http://www.ontko.com/