MS Access -- Left() and InStr() Problem
Posted on 2006-07-13
Here is my issue:
I am using the following in select statement:
It works fine when N.FirstName is two words but return nothing when it is only one word.
I understand because InStr(1,N.FirstName,' ') is returning '0' then I am tryng to get everything to the left of '0'. Is there away to put in some sort of if statement to take this into account.