In an SQL statement which concatenates several fields I get a null
value returned if any one of the fields are null.
Is this to be expected?
For example :
SELECT tblMember.memberAddress + ' ' + tblMember.memberTown + ' ' +
tblMember.memberCounty + ' ' + tblMember.memberPostCode + '<br> ' +
tblMember.memberCountry + '<br> ' + tblMember.memberInstitution AS
concatAddress FROM tblMember WHERE memberSurname='Cardy'
returns a null value if eg tblMember.memberInstitution is null.
Am I doing something wrong, if so I would be grateful for your help.
Otherwise it would be useful to know if there is some kind of work
around which can be used within the SQL statement (which is being
used in a stored procedure),
Best wishes, John Morgan