Fazendo buscas com Full-Text Search
1 2 3 4 5 6 7 |
DECLARE @termoFullText as VARCHAR(100) = '"' + 'Vict' + '*"' SELECT * FROM [Biblioteca_Editais] AS P WHERE freetext(P.[Arquivo], @termoFullText) OR contains(P.[Arquivo], @termoFullText) |