http://www.programmersheaven.com/feed/User/334998/RSS.aspx Events at Programmer's Heaven related to the user pundip. en Copyright 2013 Programmers Heaven Tue, 21 May 2013 23:32:45 -0700 Argotic Syndication Framework 2007.3.0.1, http://www.codeplex.com/Argotic http://www.rssboard.org/rss-specification 360 <p>Posted a 'new message on the Database & SQL forum.</p>I am trying to write a search form in VB6 with mutliple fields. I am using multiple “AND LIKE” in the query. The problem is that many records have NULL values so when a text box is left empty as in “” and there is a null value somewhere no records are returned. An example of the query is as follows<br /> SELECT * FROM job_ledger WHERE CompanyName LIKE '%'AND first_name LIKE '%'AND last_name LIKE '%'AND address1 LIKE '%%'AND suburb LIKE '%'<br /> The query will pull records where none of the field values is NULL. <br /> Is there a way around this if not then is there some query that I can run that makes all the NULL values “” ?<br /> <br /> Thu, 05 Mar 2009 11:21:27 -0700