At 05:27 PM 2005-08-22, you wrote: >Unfortunately this has to work in MySQL 3.23, so subqueries aren't an option. Have you considered using your favourite server side language? Simplest solution in my books. Alternatively, you could cut it off at X chars (even though that's not particularly graceful) or even every X spaces. If you assume that a sentence contains 10 spaces, you get the contents of and use a regex to make space #10 your delimiter. Frank Marion lists at frankmarion.com Keep the signal high.