Getting rid of commas from null field

[Guest]

I have the following expression in a query of a joined table.
([LastName]) & ", " & Left([FirstName],1) AS Expr1
Some of the results are null and the result is a comma by itself. When the
comma is by itself I want to get rid of the comma.

Thank you

 

[Guest]

Try something like:

iif(isnull([LastName]) & ", " & Left([FirstName],1);"";[LastName] & ", " &
Left[FirstName],1)

hth

 

[Guest]

Try

([LastName]) & ", " + Left([FirstName],1) AS Expr1

That way Null + "," will return Null

 

[Guest]

Thank you, this worked GREAT!

Try

([LastName]) & ", " + Left([FirstName],1) AS Expr1

That way Null + "," will return Null

--
Good Luck
BS"D

I have the following expression in a query of a joined table.
([LastName]) & ", " & Left([FirstName],1) AS Expr1
Some of the results are null and the result is a comma by itself. When the
comma is by itself I want to get rid of the comma.

Thank you