Home Forums SQL Server 7,2000 T-SQL SUBSTRING And CHARINDEX to find start/end of string RE: SUBSTRING And CHARINDEX to find start/end of string

  • Hmmm....these solutions would work if "CustomerFomm" is always followed by "CustomerDOB", but I don't think we should take that as a constant (without input from the OP). Once you've found the beginning of the "CustomerFomm" segment, you'd have to parse through it to find the bits you need: Between first and second tick/quote is the old data, and between third and fourth ticks/quotes is the new data. Work through that pattern and you should be able to get your solution.