SQL SELECT WHERE string ends with Column

Question

I have this table in SQL Server 2012:

Id INT  DomainName NVARCHAR(150) 

And the table have these DomainName values

1. google.com
2. microsoft.com
3. othersite.com

And this value:

mail.othersite.com 

and I need to select the rows where the string ends with the column value, for this value I need to get the row no.3 othersite.com

It's something like this:

DomainName Like '%value'  

but in reverse ...

'value' Like %DomainName 

Answer 1

You can use such query:

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