sql server - 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

question from:https://stackoverflow.com/questions/25413692/sql-select-where-string-ends-with-column

Answer 1

You can use such query:

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