Posted by KenJ on 01/26/06 06:58

I don't have access installed but, I think you can just use the left
function...

SELECT left(fieldName, 20) as newFieldName

[Back to original message]