Relative Performance in SQLServer of Substring vs a Right-Left combo
This is a performance based question, not a "I don't understand" or "best practice" question. I have a varchar field in a SQLServer database that is guaranteed to be longer than 7 chars. I need to extract a char(4) field consisting of the 2nd, 3rd, 4th and 5th chars in the varchar. For example if the varchar had the value 1234567890 I ...