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

• Next in forum: Re: Migrating to SQL 2003
• Prev in forum: Re: Truncate table if exists
• Thread view: Re: select cast help needed

[Reply to this message]