But I do want to substring(name, 5, charindex('_2_', Name) - 3)

is there a way around this dilima?

also 'funy' that the above -3 got error from SQL2k STD and with NO error from a MSDE running (both are sp3)?!

thanks
David