CF: Is it possible to display only the first few words of a memo field?

[mornings80]

I am using Coldfusion and I would like to display the first few words in a database memo (unlimited text) field as a link for the user to select the whole record. Is it possible to limit the display of the text in the memo field to just a few words?

As an example:

<A HREF="AFIELD.cfm?ID=#URLEncodedFormat(ID)#"> #AName#: #AText#:

[BKBK · Accepted solution]

Check out this function from cflib.org for getting a given number of words from a string.

[mornings80]

Thank you, BKBK!