I am currently saving information in my SQL table as a Flooddown with a rich text box in which a column is defined Which is nvarchar (MAX). The data is stored as:
& lt; Flow Document Pagepading = "5,0,5,0" Allow = "True" Number Subscription Culture Source = "User" xmlns = "http: // Schemas.microsoft.com/winfx/2006/xaml/presentation"><Paragraph> Messages at admin level Modified & lt; / Paragraph & gt; & Lt; / Flo document & gt; The problem is that when I search for this column with a keyword "user", then I want to return the records which are in the "user" paragraph and the Flooddown Not in definition. How can I modify my search to reflect user input text? Where (curl like '% user%' or '% user%') and '% numberSubstitution'
or
is not liked, where CHARINDEX (' user ', colonel, CHARINDEX' com / winfx / 2006 / xaml / presentation '& gt; ', Col)). 0
Comments
Post a Comment