<div>
No need for a case statement, you could do that with a delete statement<br />
<br />
delete from table where (charindex('S',ConsultantI<wbr />D)+charind<wbr />ex('R',Con<wbr />sultantID)<wbr />)&gt;0;
</div>


No need for a case statement, you could do that with a delete statement

delete from table where (charindex('S',ConsultantID)+charindex('R',ConsultantID))>0;

<div>
arana...<br />
<br />
I would like to use this process in a Select statement that removes the characters.
</div>


arana...

I would like to use this process in a Select statement that removes the characters.

<div>
so you dont want to delete ConsultantID but rather remove the S and R characters from the field?
</div>


so you dont want to delete ConsultantID but rather remove the S and R characters from the field?

<div>
@arana...<br />
<br />
Yes, that is correct. I just want to delete S and R characters from the string.
</div>


@arana...

Yes, that is correct. I just want to delete S and R characters from the string.

BI Director

Grayson Hampton

<div>
@arana...<br />
<br />
No I do not have a specific reason to use Case.
</div>


@arana...

No I do not have a specific reason to use Case.

<div>
then one of the above examples will work for you
</div>


then one of the above examples will work for you

<div>
Thank you arana for being extremely helpful and responsive.
</div>


Thank you arana for being extremely helpful and responsive.

<div>
<div class="content wysiwyg-content">
How do I create a Case Statetment that deletes all ConsultantIDs that have an R and/or S?<br />
<br />
<br />
ConsultantID<br />
1001004<br />
1001004R<br />
1001004S<br />
200311<br />
200311R<br />
200311S
</div>
</div>


How do I create a Case Statetment that deletes all ConsultantIDs that have an R and/or S?


ConsultantID
1001004
1001004R
1001004S
200311
200311R
200311S

Remove character from character string

Statistical packages are software titles, such as JMP and GNU Octave, and programming languages, such as MATLAB, R and SAS, that are used to discover, explore and analyze data and suggest useful conclusions, either to learn something unexpected or to confirm a hypothesis. The field includes the design and analysis of techniques to give approximate but accurate solutions to hard problems in statistics, econometrics, time-series, optimization and 2D- and 3D-visualization. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, in different business, science, and social science domains.

Statistical Packages

R is a programming language and environment used primarily for statistical data analysis.

T-SQL

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.