>Thanks!
>
>The first option works fine with [[] , but []] does not works. So I switch to CHARINDEX.
The following works.

SELECT PATINDEX('%]%','Here come the [dog]')

See Pattern Matching in Search Conditions in BOL for details.