如何连接行值以在T-SQL查询的WHERE子句中使用

I want to write a query in T-SQL to perform a search on two concatenated columns. The two columns are fname and lname. Here is what I have so far:I want to write a query in T-SQL to perform a s