Help with selecting similar names from two columns

Question

Hello

I have two columns with the names OWNER_NAME1 and BIZ_NAME.

The data is messy, so the business name and owner name may not be the same - but might be similar.

I want to select the records where the names in the two columns are similar.

I tried this but it says the expression is invalid.

BIZ_NAME = BIZ_NAME LIKE CONCAT(%OWNER_NAME1%) OR OWNER_NAME1 LIKE CONCAT(%BIZ_NAME%);

Please advise,

Thank you,

A

DavidPike · Answer

Apologies I didn't understand quite the complication of this (long day).

perhaps:

BIZ_NAME LIKE('%' || OWNER_NAME || '%')  OR  OWNER_NAME LIKE('%' || BIZ_NAME || '%')

NB I can't remember if LIKE is case sensitive in feature classes

DavidPike · Answer

where are you using this expression? what tool etc as it is important

Aique · Answer

Biz name might be Sporty and Owner name might be Sporty Associates LLC