• AndrewSQLDBA (12/11/2012)


    Hello Everyone

    I am attempting to query a column that the data has a plus sign. I know there is data, but nothing.

    I have tried multiple wildcards, but still nothing seems to work. I have even tried : LIKE '%[^0-9]%'

    This is some sample data:

    5+

    1+

    etc...

    Can anyone suggest a way to query this data.

    Thank you in advance fr your help and suggestions

    Andrew SQLDBA

    Is the data type of the column varchar or nvarchar?