NASCAR9 Intermediate
Joined: 08 Oct 2004 Posts: 274 Topics: 52 Location: California
|
Posted: Thu Oct 14, 2010 6:33 pm Post subject: NULLS |
|
|
I found this on Mullins site and thought it was pretty cool way to deal with NULLS:
Code: |
WHERE COL1 IS NOT DISTINCT FROM COL2
BOTH ARE THE SAME COMPARE
WHERE COL1 = COL2
OR (COL1 IS NULL AND COL2 IS NULL)
|
_________________ Thanks,
NASCAR9 |
|