AndrewSQLDBA (12/11/2012)
Hello EveryoneI 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?