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...