I got the idea from Scotts STUFF function and did this and it was enough for the report -

select Oppo_OpportunityId,Oppo_Description,STUFF((STUFF(oppo_SCRMcompetitor,1,1,'')),LEN(oppo_SCRMcompetitor)-1,1,'') from Opportunity where oppo_SCRMcompetitor

• This reply was modified 2 months, 1 week ago by  mathewspsimon.

I want this for building a report. Thanks Scott, I cannot run the update statement.

• This reply was modified 2 months, 1 week ago by  mathewspsimon.

yes, thank you Sue. That is what I was looking for.

Hi rVadim, I also need the PersonIDs too so that I can delete these duplicates in the end without affecting others.

Friends,the issue was resolved.I had to installed the ODAC(Oracle Data Access client) in the Cluster server also.and then the OraOLEDB.Oracle showed up in the Linked servers Provider.

Friends,the issue was resolved.I had to installed the ODAC(Oracle Data Access client) in the Cluster server also.and then the OraOLEDB.Oracle showed up in the Linked servers Provider.

I did this but my issue in the Provider Menu Item I dont see oraoledb.oracle

Yes Tnsnames is configured that is why I mentioned that I am able to connect using Oracle SQL Plus.Also these references I already saw.I am not getting oraoledb.oracle as one...

Yes the 32bit shows the drivers.But I am not able to establish the Linked server to Oraacle.

I even tried using the Microsoft driver for ODBC.But I get the following error

TITLE: Microsoft SQL Server Management Studio

------------------------------

"The linked server has been created but failed a connection test. Do...

thanks it working now.

Henrico this time there is no error but the result is as I told before and not what I was expecting.

I am on SQL Server 2005 and I get the error below when I use your query.

Msg 243, Level 16, State 1, Line 1

Type date is not a defined system...

Henrico the output is not what I want based on your query it gives the output as

Date ...