sql - How do I select rows where CONTAINS looks for value of a column, not a string -

i figured have been asked, couldn't find on stack overflow.

i have sql server table called datatable 2 columns name , message. want select rows "message" contains same value in name column.

insert datatable values ('frank','this frank's message'); insert datatable values ('jill','this not frank's message');

i want return first row, because value in [name] column ("frank") in column [message]

 select [name],[message]     datatable  contains([message],[name])

this throws error :

incorrect syntax near 'name'".

how write correctly?

you can try like, in case [name] can contained part of [message] :

select [name],[message]    datatable [message] '%' + [name] + '%'

or can use = operator in case [name] should equal [message].

Shefl