look for SUBSTRING_INDEX(field,'\.',2)
-Original Message-
From: Keith [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 8:51 PM
To: [EMAIL PROTECTED]
Subject: Limiting Return
g'day,
've had a good look through the manual and archives but can't find an
a
"Keith" <[EMAIL PROTECTED]> wrote on 11/03/2004 09:50:35:
> 've had a good look through the manual and archives but can't find
> an answer. I'm pulling, among other things, a field from the DB that
> holds description data (a few paragrahps of text). I want to limit
> it so that it only pul
g'day,
've had a good look through the manual and archives but can't find an answer. I'm
pulling, among other things, a field from the DB that holds description data (a few
paragrahps of text). I want to limit it so that it only pulls the first 50 words (or
characters if thats not possible)
Ch