>>>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.