sql - Where clause concat with comma -

i trying write thought simple clause. fullname string formatted ("doe, john"), hence clause , concat function.

here query:

    select *     table     concat(last_nm, ', ', first_nm)  = fullname;

the query fails following error:

error executing database query. [macromedia][sqlserver jdbc driver] [sqlserver]incorrect syntax near ','.

is fullname "doe, john"?
fullname complete?

if not

select * table concat(last_nm, ', ', first_nm) ('%' + fullname + '%')

Macro