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@xxxxxxxxx
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@xxxxxxxxx