Left select whole left word

G

Guest

Excuse the title - needed to attract your attention :D

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
 
B

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.
 
L

Larry Daugherty

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

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top