Thank you for your reply. Apology for the typo error and here is the updated code:

ALTER FUNCTION [dbo].[ReplaceTags2](@XML VARCHAR(MAX))

RETURNS VARCHAR(MAX)

AS

BEGIN

DECLARE @Name VARCHAR(MAX)

DECLARE CUR...

Dear Luis Cazares,

Apology for the late response. Thank you so much for your quick response and help. Apology for the lack of DDL, I will keep that...

Dear laurie, Thank you so much for your response and help. I assumed you could join null columns using either right join or full outer join, but I am so...

Dear Eugene Elutin Sir,

I apologies for misunderstanding your post message and for the inadequate message.

I would like to display all data from deal_2 (table 1) and price_2 (table_2)...

Dear Laurie,

Apology for the mistype query, as this is the original query:

SELECT d.name, d.cusip, d.isin, p.orig_price, p.price, p.cmbs_spread, p.cmbs_price, p.size, p.price_type, d.deal_type, p.date

FROM dbo.price_2 p

LEFT OUTER JOIN dbo.deal_2 d

ON...

Dear laurie, Thank you so much for your response and time. I am not sure what you mean by data not matching.

I apologies for the inaccurate data types for...

Thank you for response.

I tired posting the sample data with my original post but I was not sure how to format the data so it can be readable. ...

Thank you so much for your response and suggestion to my query.

I tired using the "RIGHT JOIN" & "LEFT JOIN" but i get 1139 instances of duplicate rows of...