<div>
Thank you very much for the help works excellent!
</div>


Thank you very much for the help works excellent!

<div>
<div class="content wysiwyg-content">
We are trying to pull the number 1 from the below string. &nbsp;To be sure its the number 1 located after the third LIT~( &nbsp;<br />
This value will always be after the third LIT~( string. &nbsp;We were trying to use the charindex but couldn't get it to work.<br />
<br />
~LIT~(sp00000009),~LIT~(),<wbr />~LIT~(1),~<wbr />LIT~(195)<br />
<br />
Thanks we are using sql 2000.
</div>
</div>


We are trying to pull the number 1 from the below string.  To be sure its the number 1 located after the third LIT~(  
This value will always be after the third LIT~( string.  We were trying to use the charindex but couldn't get it to work.

~LIT~(sp00000009),~LIT~(),~LIT~(1),~LIT~(195)

Thanks we are using sql 2000.

Substing data

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.