Hi. In my database the user will enter their address. Some address will
have up to 7 lines and some of it is optional. Since some is optional
when I concatenate the text in virtual column, the will be spaces in
lines that is blank. Can anyone help me...