Home Forums SQL Server 2008 SQL Server 2008 - General how to find ASCII characters in a table? RE: how to find ASCII characters in a table?

  • November 1, 2012 at 7:22 am

    #1554992

    mkarthikeyyan 89837 (11/1/2012)

    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!!!

    I put:

    SELECT '?' FIELD

    into SQL and it returned "?". So it may be that your query actually works, but that SQL will display the box symbol as a question mark in query results.