• I have character or symbol in my column like "?". Please help me to find out the rows which are all having this("?") character.

    My column value: Digital ? Packet Data

    I have tried the following query :

    select * from tbl_example where PATINDEX('%[?]%',field_name) > 0

    I got results with "?" character. Please help me to find "?" character in the fields.

    Thanks!!!