+ operator or .. 2

[nirajj]

SELECT table.Fname + " " + table.MI + ". " + table.LName AS Name FROM table;

I have this above query, which doesn’t seem to work properly.
Name returns blank value if MI or Lname has no value in it.
However it does show all the records, just blank values.
I am not sure if + operator is what I should be using.
All help really appreciated

 

[HandsOnAccess]

Use

SELECT table.Fname & " " & table.MI & ". " & table.LName AS Name FROM table;

It is assumed table.Fname, table.MI and table.LName are all of text data type.

Regards,

 

[RoyVidar]

He he - Null propagation ;-)

Null + "SomeValue" = Null
Null & "SomeValue" = "SomeValue

- which is why the ampersand is most often used in concatenation;-)

Roy-Vidar