-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
* and then Julie Meloni declared.... > Start with position 1. > > SELECT datefield, SUBSTRING(textfield, 1, 30) as description FROM > tablename WHERE id = 2; Hi again Julie and thanks for 'cross list' help! The problem is not that, at least not first anyway. Here is what I've get: You have an error in your SQL syntax near 'desc FROM news ORDER BY date ' at line 1 That comes from exactly what you have above, it works without the 'as desc' part but then I have no way to get at it? Cheers... - -- Nick Wilson // www.tioka.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE9CRrxHpvrrTa6L5oRAg87AKCYM0MrVcnX3X9ZvMOW6Ncm47EnCQCbBO+J t0TWKjK81rSD9mc/lfWed/s= =6q25 -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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