- Code: Select all Expand view
- SELECT * from vll_term WHERE WORT LIKE '%' + UNHEX('C39F') + '%'
The result is not as expected, maybe there is something wrong with the syntax?
The Google answer is:
![Image](https://i.postimg.cc/6Q3WfWWr/notfound.png)
ChatGPT:
![Image](https://i.postimg.cc/KvJCrnRW/2023-11-17-08-26-15.png)
The correct syntax is therefore:
- Code: Select all Expand view
- SELECT * FROM vll_term WHERE WORT LIKE CONCAT('%', UNHEX('C39F'), '%');
The answer was very helpful for me
![Very Happy :D](./images/smilies/icon_biggrin.gif)