View Single Post
  #2 (permalink)  
Old January 15th, 2004, 11:00 AM
planoie's Avatar
planoie planoie is offline
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

I haven't found such a beast. One thing you can consider if you are using a SQL DB (not sure about Access): if you know what columns you might get db nulls on you can write the query to handle this. Instead of just selected the column value, use the COALESCE() function to get the first non-null value.

SELECT COALESCE(myColumn, '') ...

Peter
------------------------------------------------------
Work smarter, not harder.