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]
.
Comments
Post a Comment