Re: quote-space-quote -Reply

[Jim Hardesty <jhardest@LMBERRY.COM>]

>>> Keep in mind this **silliness** of every column being not null seems to be
PeopleSoft specific

It isn't silliness when you want to write a query using <>.

for example if sales type is null for non-sales employees, this query does not
return non-sales employees.

select name, deptid
from employee_tbl
where sales_type <> 'B'

not much fun having to put 'and not null' on bunches of queries.

jim