I have two queries:
Select description --description field datatype is ntext
From tableA
Where description like '%' + char(1) + '%'
and
Select description
From tableA
Where description like '%%''
where char(1) =
The first query returns numerous row where as the second returns none, can anyone explain this behaviour. I am trying to find and replace control characters with an empty set but I am having trouble finding them all, not to mention replacing them.
Select description --description field datatype is ntext
From tableA
Where description like '%' + char(1) + '%'
and
Select description
From tableA
Where description like '%%''
where char(1) =
The first query returns numerous row where as the second returns none, can anyone explain this behaviour. I am trying to find and replace control characters with an empty set but I am having trouble finding them all, not to mention replacing them.