I need help to write an expression that will delete any text string after the first occurence of a white space character.
This query seemed to do the job on some records, but not others.
SELECT T.Field, IIf(InStr(1,[T.Field," " Or " " >0,Trim(Left(T.Field,InStr
," " Or " "))),T.Field) AS Expr1
I copied and pasted the white space characters and put them into the query, but it doesn't recognize some of them.
I've attached an Access file with some test records.