SQL Server : find all stored procedures containing Left(column,5)
<p>I'm using SQL Server 2014 and I need to find all stored procedures that use a <code>Left(Column, 5)</code> function</p>

<p>For example, it should find </p>

<pre><code>left(jobno, 5) 
</code></pre>

<p>but not </p>

<pre><code>left(jobno, 50)
</code></pre>

<p>it should find </p>

<pre><code>left(ZIP, 5) 
</code></pre>

<p>I initially thought I could use</p>

<pre><code>Like '%Left(%,5)%'
</code></pre>

<p>but it returns no records</p>

<p>Thanks</p>

<p>mark</p>