Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more - View Single Post

clifford · 11-01-2005, 11: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

11-01-2005, 11:17 AM	#1 (permalink)
clifford Junior Member Join Date: Jun 2005 Location: Finland Posts: 26	Limit disply of text field in table view 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