Joseph Crawford Thu, 08 Dec 2005 12:55:24 -0800
you can try this select SUBSTRING(field,0,100) from table
-- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]