Sql Server extract string inside a text
<p>How i can find the 'azerty' string part inside a field that containing this kind of text:</p>

<pre><code>DECLARE @s VARCHAR(max)

SELECT @s='Num Fourn:FST00100
Ref Fourn:azerty
PU HT:10
Remise(%):
Coef:2

*** Veuillez remplir les infos ci-dessus sans modifier la structure des lignes ***
Exemple:
Num Fourn: FST00100
Ref Fourn: ABC123
PU HT: 5.30
Remise(%): 10+5
Coef: 2.26'
</code></pre>