sql server 2008 - Syntax error on full text search -

i trying search data can match set of columns.

when run

declare @name varchar(80)           = 'wisr aaron' select id data (nolock) contains(*, @name) 

i error message

msg 7630, level 15, state 3, line 5 syntax error near 'aaron' in full-text search condition 'wisr aaron'. 

msg 7630 suggest that

declare @name varchar(80)           = 'wisr near aaron' select id data (nolock) contains(*, @name) 

is solution. tried running it. did not crash there not results either.

is there way without having add near on place?

you should add double quotes if wanna words space.

declare @name varchar(80)           = '"wisr aaron"' 

but doubt result if near version didn't anything... (maybe rebuild index ?)