String or binary data would be truncated error with fuzzy join
<p>I have the below query which I'm trying to bring through all objects which use a scalar value function however I get a String or binary data would be truncated error. Please assist.</p>

<pre><code>Select 
    definition 
From
    sys.sql_modules M
Join
    (Select 
        name 
    from 
        sys.objects O
    where 
        type_desc = 'SQL_SCALAR_FUNCTION')T
on 
     '%' + T.name + '%' Like '%' + M.definition +'%'
</code></pre>