<div>Thanks Chris,</div> <div>I got the answer from the link you post:</div> <div> </div> <div>my $sql = 'is not null';<BR><BR> my @rows = Some::CDBI->search_where(<BR> some_column => \$sql<BR> );</div> <div> </div> <div>Regards,<BR><BR><B><I>"Christopher H. Laco" <claco@chrislaco.com></I></B> wrote:</div> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Will Smith wrote:<BR>> Hi, <BR>> first, thanks for all of your help.<BR>> A simple question I want to ask is how to do a search for NOT NULL value. I do not want to use ->search_like<BR>> <BR>> Thank you<BR><BR>On what Model? A DBIC based Model?<BR><BR>{column => {'!=', undef} I'd assume...<BR><BR>-=Chris<BR><BR>_______________________________________________<BR>List: Catalyst@lists.rawmode.org<BR>Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst<BR>Searchable
archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/<BR>Dev site: http://dev.catalyst.perl.org/<BR></BLOCKQUOTE><BR><p> 
<hr size=1><a href="
http://us.rd.yahoo.com/evt=49981/*http://advision.webevents.yahoo.com/mailbeta/features_spam.html">Sucker-punch spam</a> with award-winning protection.<br> Try the <a href="
http://us.rd.yahoo.com/evt=49981/*http://advision.webevents.yahoo.com/mailbeta/features_spam.html">free Yahoo! Mail Beta.</a>