Sybase escape character

Looking for ROGER contained in square brackets in a character field.

select * from myTable where myColumn like "%[[]ROGER[]]%"
select * from myTable where myColumn like "%@[ROGER@]%" escape "@"

---

Roger Hall COMPUSPEC

Web Compuspec.net