Case1182 Posted July 28, 2007 Share Posted July 28, 2007 I am having a big issue, if one of the values of the field the parameter is comparing its self to is null it excludes the whole record, because % wildcard will not pull up nulls, this means I am not display 56 records on my report, I need a way to make these show up if the are null and ISNULL, NVL AND COLESCE are not working, they will change it on the report but the parameters are still comparing to the null value not the new value, causing the same problem, :huh: Link to comment Share on other sites More sharing options...
codyjasperForge Posted July 28, 2007 Share Posted July 28, 2007 Do you have the option of placing a "NO NULLS" constraint in you dB? To me this seems like the only way to avoid such a problem... Link to comment Share on other sites More sharing options...
svenn Posted July 28, 2007 Share Posted July 28, 2007 You could try using a decode statement to convert the null values to something else. You could then evaluate that value. Link to comment Share on other sites More sharing options...
nittu02 Posted August 9, 2007 Share Posted August 9, 2007 when you compare the field with the parameter value, if it is a null, you can include an or condition so as to pull the value, right? for example, select * from accounts where (number<5 or number is null) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now