Concatenated string as parameter
Posted on 2012-09-21
I have a concatenated field that includes Address fields and correspondence address fields.
e.g. addressline1+' '+addressline2+' '+postcode+' '+correspondence_address1+' '+correspondence+address2+' '+correspondence_postcode as fulladdress
This field is used as a parameter in a report. users must enter a character when prompted. The problem I am having is that sometimes a correspondence address is null but the addressline1 and addressline2 would always have a value.
As an example if I enter 'b' in the search test box and 'fulladdress' contains 'b', data is returned but when correspondence_address1+' '+correspondence+address2+' '+correspondence_postcode is null, no data is returned
I have tried replacing the null value with spaces but this has not worked.
Please can anyone suggest a ny wok arounds?