Return text amount anding with a full word

[Eric Creese]

I want to return a portion of text provided the last word is the full word.

I understand I can use this SQL: select left(textfield,100) from table. But I want to get a whole last word not truncate it. I am sure this has been discussed before.

Thanks Eric

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---