Limit disply of text field in table view - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

clifford · 11-01-2005, 10:17 AM

I have database with a table that has a text field. When diplayed though I only wish to disply the first 20 charachters from this text field.

Query = "select table1.rec_id as 'Record ID', table1.NOTES as 'NOTES' from table1";

How do I limit the displayed NOTES field to only the first 20 chars.

thanks

taylor · 11-08-2005, 08:39 PM

Hey ~clifford.. just trim the results

Code:

Query = "select table1.rec_id as 'Record ID', LEFT(table1.NOTES, 16) as 'NOTES' from table1";