Sql LIKE statement. End Of String

Question

I have to select all fields which contain a specific text and ended with ", ', ) or blank space characters or this text is placed in the end of string.

So, I need something like that:

select *
from MyTable
Where Column1 like '%' + @text + '["'') ]%'

This query works fine until text is not placed in the end of Column1.

Answer 1

You could use

Where Column1 + '"' like '%' + @text + '["'') ]%'