<div>
something like... ( not tested so you might have to play with the len in the substrings ie -1 or not a bit.<br />
SELECT <br />
&nbsp; &nbsp;CASE &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; WHEN CHARINDEX( '+', &nbsp;myField) &gt;&nbsp;0<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; THEN &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SUBSTRING( &nbsp;myField, 1, &nbsp;CHARINDEX( '+', myField ) -1 )<br />
&nbsp; &nbsp; &nbsp; &nbsp; ELSE MYFIELD<br />
&nbsp; END AS LEFT_FIELD,<br />
&nbsp; CASE &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; WHEN CHARINDEX( '+', &nbsp;myField ) &gt;&nbsp;0<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; THEN &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SUBSTRING( &nbsp;myField, CHARINDEX( '+', myField ) +1 , LEN(myField) -CHARINDEX( '+', myField ) - 1 &nbsp; )<br />
&nbsp; &nbsp; &nbsp; &nbsp; ELSE <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myField<br />
&nbsp; END AS RIGHT_FIELD,<br />
FROM myTable
</div>


something like... ( not tested so you might have to play with the len in the substrings ie -1 or not a bit.
SELECT
   CASE  
        WHEN CHARINDEX( '+',  myField) > 0
                  THEN    
                           SUBSTRING(  myField, 1,  CHARINDEX( '+', myField ) -1 )
        ELSE MYFIELD
  END AS LEFT_FIELD,
  CASE  
        WHEN CHARINDEX( '+',  myField ) > 0
                  THEN    
                             SUBSTRING(  myField, CHARINDEX( '+', myField ) +1 , LEN(myField) -CHARINDEX( '+', myField ) - 1   )
        ELSE
                myField
  END AS RIGHT_FIELD,
FROM myTable

<div>
oops still busy typing and angell has already given answer &nbsp;Sorry<br />

</div>


oops still busy typing and angell has already given answer  Sorry


<div>
<div class="content wysiwyg-content">
Hi There<br />
<br />
I have a string that comes through as follows<br />
A24+B34.56* &nbsp;or sometimes comes through like this A24 or B34.78<br />
<br />
I would like to check the string in my stored procedure.<br />
If there is a + sign in the string I want to split the string into 2 values using the plus sign as the delimiter.<br />
If there is no plus sign I would just like to use the value as it comes.<br />
<br />
Thanks<br />
Stanton<br />
<br />

</div>
</div>


Hi There

I have a string that comes through as follows
A24+B34.56*  or sometimes comes through like this A24 or B34.78

I would like to check the string in my stored procedure.
If there is a + sign in the string I want to split the string into 2 values using the plus sign as the delimiter.
If there is no plus sign I would just like to use the value as it comes.

Thanks
Stanton



Split string in SQL Stored procedures

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.