SELECT SUBSTRING(SÖKORD, 0, CHARINDEX(':', SÖKORD, 0)) AS Part,
SUBSTRING(SÖKORD, CHARINDEX(':', SÖKORD, 0) + 1, 100) AS KeywordName, *
INTO #LIVSRWTMP
FROM [DATALAGER].[DW].[medrave].[vJournalAnteckningar]
WHERE patient_wid = '672846'
DELETE FROM #LIVSRWTMP WHERE VÄRDE LIKE '%#%'
SELECT * FROM #LIVSRWTMP