Hey Phil,

You are correct had 30,000+ records with the word "Responsibility" misspelled and 400+ spelled correctly.  Ran replace function to correct the misspelling.

SELECT Pos1 = CHARINDEX('Total Paid amount is $',...

• This reply was modified 3 years, 9 months ago by Tav29.

Fixed. Absolute Value (ABS)

Phil,

I'm getting this error. Here is my sql statement:

SELECT Notes, NoteId

,TotalPaid = SUBSTRING(Notes, c.Pos1, c.Pos2 - c.Pos1)

FROM dbo.NoteReceive

CROSS APPLY

(

SELECT Pos1 = CHARINDEX('Total Paid amount...

Never mind Phil, I got it. Thank you for your help.  also thank you Jonah.

Thanks Phil,

I'm sorry for such a novice question(New to SQL) I have this information in a Notes Field along with an ID Field in a table. How do I reference...

Hi Phil,

I'm trying to exact the Payment information (In Red). My problem is they all have different starting positions,  I did the Charindex recommend by Johan and I get 42,43,44,45,46...

Thank you Johan,

I tried the Charindex and I'm able to find the starting position. I have multiple positions 42,43,44,45,46.  What's the best way to go about this? a Case statement...