Posted by T.M. on 01/26/06 07:10

Thank you.
That works for one field. What if I wanted to get the first 20
characters from multiple fields? I'm trying to display the first few
lines of few articles. Each article has its own field in the db. Any ideas?


KenJ wrote:
> 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]