instr() for SQL?
Posted on 2004-03-25
Just a quick question. I need a way to strip part of a field out, the amount I need to strip out is variable but it always the last part of the string/field. I need to do this purely within SQL.
Ideally I want something similar to the basic Instr() command that will let me know when the part I need to strip starts (in this case the part I need to remove always starts with 'chase' but can and most likely will have characters after it. Once I have that I can use mid, left or any number of things to do the stripping itself.