db2 special character 0x1A

Question

Hi,

how can I seach for a spezial character like "→" (0x1A). An example for my query is:

select * from Data where Name like '%→%'

I want to use instead of "→" somethoing like 0x1A

I can't use any Java or C# Code. I just have SQuirrel to connect and send commands to the database.

Thanks Stefan

Answer 1

You can use chr() to search the charater:

select * from data where name like '%' + chr(26) + '%'

Answer 2

Solution 1: Use chr(26).

Solution 2: Write the query in Java or another programming language which lets you build the SQL from pieces and where you can enter hex codes.