Hi,
I want to get all records from Tab1 and the first 20 words for the fieldA

SELECT *, LEFT(fieldA, 20) AS fieldA FROM Tab1....

But this query does not work: why?

thanks!

--
http://www.spacemarc.it

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to