Query to return First word

[billybeer]

I am trying to run a query that will return the first word in a column. I have this; ​Expr1: Left([DFFNAME],InStr([DFFNAME]," ")-1)


This works when there are multiple words in the column but errors out when there is only one word in the column. What do I need to add to return the first word when there are multiple words and return the one word when there is only one word in the column. This is for a column of first names [DFFNAME] that sometimes has just a first name and sometimes has both first and middle names and I only want the first. Thanks

[JoeM]

Try this:

​Expr1: IIf(InStr([DFFNAME]," ")>0,Left([DFFNAME],InStr([DFFNAME]," ")-1),[DFFNAME])

[JoeM]

Alternatively, you could also do it like this:

Expr2:Left([DFFNAME] & " ",InStr([DFFNAME] & " "," "))

[billybeer]

Works great, thanks for quick response.