Is there a t-sql equivalent to starting a substring from the right? And an instring equivalent? I see that there is a "right" function, to start from the right (I'm on the correct path here, yes?), but I don't know the "instring" equivalent to tell it how many characters to go.
Thank you --
Not really, though you can use REVERSE function.
You may find the following string functions helpful, though
Premature optimization is the root of all evil in programming. (c) by Donald Knuth
Naomi Nosonovsky, Sr. Programmer-Analyst
Have a look at CHARINDEX, this is basically the T-SQL versino of InString.
You might also be interested in PATINDEX.