<div>
substring(column, 0, charindex(column, '&lt;style&gt;'))<br />
<br />
or something similar to this
</div>


substring(column, 0, charindex(column, '<style>'))

or something similar to this

<div>
You can use <br />
select substring(columnname,0,cha<wbr />rindex('&lt;s<wbr />cript&gt;',co<wbr />lumnname))<wbr /> from tablename. <br />
<br />
But it will return null if the the column doesnot contain '&lt;script'&gt;. If u want those result to u can use the following code<br />
select case substring(columnname,0,cha<wbr />rindex('&lt;s<wbr />cript&gt;',co<wbr />lumnname))<wbr /><br />
when '' then columnname<br />
else substring(columnname,0,cha<wbr />rindex('&lt;s<wbr />cript&gt;',co<wbr />lumnname))<wbr /> end<br />
&nbsp;from tablename
</div>


You can use
select substring(columnname,0,charindex('<script>',columnname)) from tablename.

But it will return null if the the column doesnot contain '<script'>. If u want those result to u can use the following code
select case substring(columnname,0,charindex('<script>',columnname))
when '' then columnname
else substring(columnname,0,charindex('<script>',columnname)) end
 from tablename

<div>
<div class="content wysiwyg-content">
i would like to retreive part of a string which is in a column of data type ntext. The column has a lot of html. I would like to retrieve the part till i reach '&lt;style&gt;'.<br />
<br />
Everything &nbsp;before '&lt;style&gt;' should be retrieved.<br />
<br />
Please suggest with syntax.<br />
<br />

</div>
</div>


i would like to retreive part of a string which is in a column of data type ntext. The column has a lot of html. I would like to retrieve the part till i reach '<style>'.

Everything  before '<style>' should be retrieved.

Please suggest with syntax.



SQL Server 2005: How do i get the value from a field till i reach a particular string like &lt;style&gt;?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

SQL Server 2005: How do i get the value from a field till i reach a particular string like &lt;style&gt;?

SQL Server 2005: How do i get the value from a field till i reach a particular string like <style>?