Nevermind I found something.
  ----- Original Message -----
  From: Eric Creese
  To: CF-Talk
  Sent: Sunday, May 30, 2004 12:43 PM
  Subject: Return text amount anding with a full word

  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]

Reply via email to