From: Clifford Heath Date: 2007-11-09T10:15:02+09:00 Subject: Re: find with null gives exception Junkone wrote: > this one gives me a exception. what is the syntax if i use the find > and wnat to return records with certail column null in it. > Rawdata.find(:all, :conditions=>{:processed_indicator => NULL }) Please ask Rails questions on the Rails list. You want: Rawdata.find(:all, :conditions=>["processed_indicator is NULL"])