return rows that start with ADP[Y]

Question

Hello!

I have a column called ProductID.

Example:

('ADP[Y]2149')

('ADP[X]6433')

I have tried this query.

select * from Producttable where ProductID like 'ADP[Y]%'

But the query did not return any rows.

I need to return rows that start with ADP[Y].

Answer 1

Hi @T L

You can try this.

select * from Producttable where ProductID like 'ADP\[Y]%' ESCAPE '\';

Best regards,

Percy Tang