Restricting What"s Retreived

------=_Part_30383_8658737.1134074269818
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Does anyone know when you get info from a DB, can you restrict how many
characters it gets from it? say you had a paragraph 1,000 letters but you
only wont it to get 100 how would you do that?

------=_Part_30383_8658737.1134074269818--

Re: Restricting What"s Retreived

------=_Part_23205_18269563.1134075276345
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

you can try this
select SUBSTRING(field,0,100) from table

--
Joseph Crawford Jr.
Zend Certified Engineer
Codebowl Solutions, Inc.
1-802-671-2021
codebowl@gmail.com

------=_Part_23205_18269563.1134075276345--