Name space issue

[Noah114]

I am trying to create a function in a query that will pull the first letters of a name before the space. For example, I can get "JOHN" or "JOHN S." under first name. I try

Trim(Left([FIRST_NAME],InStr([FIRST_NAME]," ")))

But when I do than I get nothing back for the first on and JOHN back for the second. Any suggestions?

 

[Golom]

IIF(InStr([FIRST_NAME]," ")>0,
    Trim(Left([FIRST_NAME],InStr([FIRST_NAME]," "))),
    [FIRST_NAME})

 

[Golom]

Sorry ... typo

IIF(InStr([FIRST_NAME]," ")>0,
    Trim(Left([FIRST_NAME],InStr([FIRST_NAME]," "))),
    [FIRST_NAME[COLOR=red yellow]][/color])