>>I can't test this right now (I install some SP here)
>>but what if you change declarations of the variables from CHAR() to VARCHAR()?
>
>Changing to varchar will find the records.
>
>But, why?
Because there are no trailing spaces after [%] sign.
You search for:
[Axxxxx% ] && up to 20 chars
not for
[Axxxxx%]
And I am not sure how SQL Server acts that way. The SP is still installed so I can't run SSMS right now :-( and check it.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.