Q&A about the site for developers and researchers interested in open data
DECLARE @String varchar(50) = 'Acetaminophen 21.7 MG/ML / Dextromethorphan Hydrobromide 1 MG/ML / doxylamine succinate 0.417 MG/ML Oral Solution' SELECT LEN(CHARINDEX(@string, ' / '))