select left(field,200) + '...' as ShortField from table
--
Jules
Team Macromedia
http://charon.co.uk
ICQ 51328805
CharonCart II (£free)
Ultradev 4 shopping cart extension
http://charon.co.uk/charoncart
"Matt Lane" <ml...@thefoundationdesign.com> wrote in message
news:B802F5BA.25E0%ml...@thefoundationdesign.com...
Or use the trim text extension: www.UDzone.com/go?68. However be aware that
the method provided by Jules seems to perform better in some situations (or
am I wrong Jules?).
--
Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------
--
Jules
Team Macromedia
http://charon.co.uk
ICQ 51328805
CharonCart II (£free)
Ultradev 4 shopping cart extension
http://charon.co.uk/charoncart
"Waldo Smeets - UDzone.com" <em...@waldosmeets.com> wrote in message
news:9rjikt$r6t$1...@forums.macromedia.com...