SQL how to displayed result between to known phrases that will always been in the cell
<p>I have been reading up on this quite a bit, and am struggling to figure out how to do this.</p>

<p>Basically, I have a column that I have identified as Member_Type, and what displays in this column is a connection string that looks like the following:</p>

<p>Provider=SQLOLEDB.1;User ID=User;Password=Password;Data Source=Hostname;Initial Catalog=DESIRED_RESULT;Persist Security Info=TRUE/FALSE;Min Pool Size=5;Max Pool Size=x</p>

<p>Basically, in all of the connection strings, the ONLY thing I want to return in the results of the Member_Type column is everything AFTER the phrase "Initial Catalog=" but before ";Persist Security," as these phrases will appear in every result, and the variable and important information is the Initial Catalog database name that will be returned.</p>

<p>Since the User ID's, Passwords, and Data Sources will all vary at hundreds of different sites, a character count may not work for me.</p>

<p>Would anyone be able to tell me how to JUST get the result that appears between Catalog= and ;Persist?</p>

<p>Thank you!</p>