How to remove double quotes when concatenating a string in Oracle

[crystaldev1]

I'm using CR 2008 and Oracle database. From Oracle, it looks like if I'm concatenating a field with a string, it adds "" to the value in the report (e.g. ',,' || Field1 ). Just a field itself would not show double quotes but if I add two commas, it's showing up with double quotes. I would like it to appear as ,,field1value (not ",,field1value"). Thanks.

 

[hilfy]

Does it appear this way when you're previewing the report or when you export? If it's on export, what format are you exporting to? Are you doing the concatenation in Oracle or in Crystal?

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com