Left function

[sameersabri]

Hey Everyone!

How can I take two or three words from left side of a field in access 2007 query, where it is separate with comma, dash, space or double space
thanks!

 

[arnelgp]

use split() function.

 

[Guus2005]

Please provide some samples to work with. When do you need two and when do you need three words?

Here a rough sketch on how to do it.
Replace comma, dash, space and/or double space with a unique character like a comma.
using the split command you can separate the second or third word from the query result.

HTH

 

[sameersabri]

Thank you guys!