Please describe. I am trying to split a column with comma demented strings (e.g. cat,dog) into two separate columns. I tried various things - this seems to be most useful https: ... Add CHARINDEX SQL ...