Forum Moderators: open
Because our site features beers from around the world, we have plenty of non-U.S. characters, so a search for "beer" is coded as
SELECT * FROM Beer WHERE BeerName LIKE '%b[eéêëè][eéêëè]r%'
but when I try
SELECT * FROM Beer WHERE CONTAINS(BeerName, 'b[eéêëè][eéêëè]r')
I get
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error occurred near '['. Expected ''''' in search condition 'fr[aáâãäåæ][nñ]k'
Smart people, please enlighten me!