Hello, i have a problem with the LIKE search when i use words with accent (spanish words). I have this stored procedure:

CREATE PROCEDURE xs_aut_lst_authorOBid2
(
@str_substring VARCHAR(200)
)
AS
SELECT AUTHOR.aut_id, AUTHOR.aut_name FROM AUTHOR
WHERE AUTHOR.aut_name COLLATE SQL_Latin1_General_CP1_CI_AI LIKE
'%' + @str_substring + '%' COLLATE SQL_Latin1_General_CP1_CI_AI
ORDER BY AUTHOR.aut_id
RETURN
GO

When i execute the sp from sql query analizer works fine, so i get the same results executing Exec xs_aut_lst_autorOBid2 'german'
or Exec xs_aut_lst_autorOBid2 'germán'

But when i call the stored procedure (Exec xs_aut_lst_autorOBid2 'german')
from a visual basic DLL, using ADODB, i get no results. (Exec
xs_aut_lst_autorOBid2 'germán' still works fine).

Any ideas?

Thanks,