SQL SELECT WHERE string ends with Column

You can use such query:

SELECT * FROM TABLE1
WHERE 'value' LIKE '%' + DomainName