I think excluding the rows that do not have a '-' in them would work

Perhaps i can build an IIf statement around the Parsename function ?

i can achieve omitting nulls within query with the following but is there a way to omit nulls within the parsename statement itself

SELECT    ...

Thanks so much guys

I think the Select MyValue = parsename(replace('2C00P02-CRIW-93201', '-', '.'), 2) will work

Some values in the table are like 123 bgbb bfbfb (without no dashes etc.) so when...