Thanks Caroline,

I'm doing that now with the vfp report writer, but I'm creating a Crystal report to replace the vfp report and wasn't sure how that would work in CR...

Jim


>Another option may be to create a UDF that way you can make the expression as complicated as you want.
>HTH
>CAroline
>
>>I think I answered my own question. The resultant field length, even with all the trimming is probably over the allowable field length (256 c)???
>>
>>The reason I was trying to get all this information into one field was because I was going to use the data in a Crystal Report, and I thought it would be easier with one field...
>>
>>