sql server - how to get result if value is comma seperated in like codition -

i trying following query not getting results:

select *  internationalpropertylocals   propertyname '%chatham,ma%'

but if try below query expected result:

select *  internationalpropertylocals  propertyname = 'chatham, ny'

are missing whitespace after comma?

try:

select * internationalpropertylocals propertyname '%chatham, ma%'

if know exact propertyname looking avoid using like = describes intentions better, not mention performance concerns.

Click Hand