On 14 Jun 2002, at 0:03, Nick Wilson wrote: > SELECT date, SUBSTRING(text, 0,30) as description FROM table WHERE id > = '2';
You can't assume that MySQL is like Perl, PHP, or any other language you may be used to. Note this: "For functions that operate on string positions, the first position is numbered 1." http://www.mysql.com/doc/S/t/String_functions.html You could also use LEFT(text, 30). [Filter fodder: SQL] -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php