Both solutions works perfectly, thank you very much for the help.

Thank you both for the solution.

Actual requirement is I need to find Start Date and End Date difference between these 2 dates and see which year it will fall each...

Thank you so much for the help.

Thx for the reply.

Now it removes the tags.

Now it looks like this:

Test ticket   Thank you,   Regards    

'&' represents next line, those still remains.

Thx

Regards

Vijji

It has to be in the Text format.

I need to display this field in SRS report without XML tags.

Thank you,

Regards

Vijji

Thank you ashokdasari, it worked perfectly..

Data Type is Char

Thank you so much, it is working.

Regards

Vijji

Thank you for the suggestion

I tried using PIVOT, but rows are repeating.

SELECT PT_Window_ID, PT_UD_Key, [4] as Manufacturer, [6] as SHIPTERM

FROM EXT00101

PIVOT

(max(STRGA255) FOR PT_UD_Number in ([4], [6]))

AS pvt

WHERE...

THX Peso & TO ALL

THE BELOW SCRIPT IS WORKING FINE.

ALTER TRIGGER dbo.tr_SVC_SVC00701_InsertAddress ON dbo.SVC00701

FOR INSERT

AS

UPDATE ...

Hi Karl

after i remove IF @@rowcount = 1, it is updating only for the last record, remaining records are blank.

Thx

Regards

vijji

Hi Ray M

Thx for your help, it is working.

Hi

Table01 all fields having Account index.

I need to link Table02 and display discription for all fields Account description

thx

Hi

Hi

I am adding calculation column.