I put a couple of these solutions together. It worked great. Thank you everyone for your help.
>I found that chr(28) is not the actual code for left double quote >copied from Word. It is the resulting code when we try to store the >actual code, chr(8220), to our Oracle DB. To cover new and old data, >we do a replacement on both. The full code we use is below. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242038 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

