No it wouldn't. Not if you tell the CHARINDEX to start looking for an underscore after the position of the first underscore. Since the prefix of the file names seems...

In reply to Jeff Moden's post:

I was wondering why you're using a replace in the SUBSTRING command to select the value for Y? Wouldn't it be easier to supply the...