Thank you everyone for your help, especially Sean.

The underlying problem was casting a varchar(max) into a decimal. If I change this to cast to a float the problem goes away.

Many...

Sean you are quite correct. I've a web application that users can pick fields from dropdowns & operators etc and enter selection criteria. This data is then used to dynamically...

The CROSS APPLY seems to return the results in triplicate. I can't use DISTINCT as i've other columns in my select.

The NOLOCK hint is for speed, the query is over...

I included the definition of the function in my original post. The purpose of it is to take a delimeted string and return it as a table you are then...

I've tried this

set @sql = 'SELECT [id]

FROM [dbo].[test] WITH (NOLOCK) WHERE id IN (select Item from dbo.FN_DELIMITED_STRING_TO_TABLE(''1000,2000,3000'','',''))

ORDER BY id'

as you suggested. The query when...