I have some data which is flowing from the table source to a flat file. However, while the data is flowing into the flat file, quotations are coming in the data, which needs to be removed.
The select query i have tried in finding the error is this:
select LTRIM(ISNULL(RTRIM(FIRST_NAME)+'','') +ISNULL(RTRIM(LAST_NAME),'')) as PersonName
I searched over the flat file to find quotations in the data and i found one person name where quotations are present. The record is like this AnitaDesai "pandey", whereas the remaining records contain only 2 words. For example: AnitaDesai..Only this record is odd and the last word is embedded in quotations. How do i remove the quotations? I want to replace the quotations with spaces.