Hello,

Thanks for the reply.

I was hoping I could use the existing field and just search for CHR(13) in a Formula Field.
If this is not possible, I will have to add another field to the database.

Thanks,

TFISHER

>Create deferente fields in your data for every format of output.
>Then in the Crystal Report you use the one you need for the report.
>

>Select address,strtran(address,chr(13)) as AddressNoCR from MyDate
>

>
>>Hello,
>>
>>I have an address where I would like to be able to display two different ways.
>>
>>The first way is as follows:
>>
>>222 Address Street
>>YourCity, YourState 55555
>>
>>The second way is as follows:
>>
>>222 Address Street, YourCity, YourState 55555
>>
>>I am currently placing a CHR(13) in the string.
>>
>>Is there a way, using Crystal Reports Developer version 9, to search for the CHR(13) and replace it with a space?
>>
>>I have tried the REPLACE command in Crystal, but I can not get it to find the CHR(13) -- at least, I can't get the string to display all on one line.
>>
>>Any ideas how to do this?