>Hi,
> I am displaying an address on a screen. I concatinate the address, and include the CHR(13)'s to give it lines. I do this incase AddressLine2 is blank. This also lets me get the city, ST ZIP in a nice format. The problem is that if the address lines are too long they will wrap. (ie. all 'W'). How do I cut them off at a given apearant screen length, so that they will not wrap? Thanks.
>
>Daniel
SUBSTR(lnAddr1,1,25)
This will only show 25 characters of the value.
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown