Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Hi, i have following data. 'ÿ9998r9998i4~085.2 : Cutaneous leshmaniasis, Asian desert ÿ9999r9999i3~153.2 : Neoplasm, malignant, of colon, descending colon ÿ9999r9999i2~023.3 : BRUCELLA CANIS ÿ9998r9998i3~085.2 : Asian desert cutaneous leshmaniasis ÿ8888r8888i5~1119F : INITIAL EVAL FOR CONDITIONücertified ÿ8888r8888i3~1110F : PAT LFT INPAT FACE W/IN 60 DAYSünoncertified ÿ9997r9997i3~085.2 : Leshmaniasis, cutaneous, Asian desert ÿ9998r9998i2~023.3 : Infection due to Brucella canis ÿ8888r8888i4~1111F : DISCHARGE MED/CURRENT MED MERGEücertified ÿ8888r8888i2~11100 : BIOPSY SKIN LESIONüpending ÿ9997r9997i2~023.3 : Brucella canis infection ' TableName Diagnosis completedflag 1.But i need to delete from 'ü' to 'ÿ' .for example: PAT LFT INPAT FACE W/IN 60 DAYSünoncertified ÿ9997r9997i3~085.2output:PAT LFT INPAT FACE W/IN 60 DAYS 9997r9997i3~085.2please any one giude me.
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs