Left select whole left word

[Guest]

Excuse the title - needed to attract your attention

I have a field that lists titles/names that may run to several words

This is probably the most simple thing ever but is anyone aware of the
syntax for selecting the left word only?

regards

PMK

 

[Brendan Reynolds]

SELECT Left$([TestText],InStr(1,[TestText]," ")-1) AS LeftWord
FROM tblTest
WHERE (((tblTest.TestText) Is Not Null));

See Left Function and InStr Function in the help files for more information.

 

[Larry Daugherty]

Hit F1 and look for the string manipulation functions. Mid$() might be a
good place to start.

HTH