RE: Limiting Return

2004-03-11 Thread electroteque
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

Re: Limiting Return

2004-03-11 Thread Alec . Cawley
"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

Limiting Return

2004-03-11 Thread Keith
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