>>>What is fred doing at the end of your code - was it for test? Add print @SQL before executing, you will see the error.
>>>
>>
>>See my reply to Boris.
>
>You have an extra + before like.
>
>It should be
>

>where myField LIKE '%' + @SomeNumber + '%'

>

I am concatenating strings, this is my current code:

SET @sWhereClause = @sWhereClause + @NewLine + ' AND [cus_number] LIKE + ''%'' + @cus_Number + ''%'''

strangely enough it works as is, but I'm not quite understanding how the string concatenation is working here anyhow.

>Also, if the number is nchar(5) when what is the point of using LIKE at all? You should use
>
>Number = @SomeNumber

See my conversation with Boris regarding this.