tmajor99

<div>
If it is ALWAYS that string, replace it?<br />
<br />
Oracle:<br />
replace(name,'<a href="http://attribute?id='" rel="ugc">http://attribute?id='</a>)
</div>


If it is ALWAYS that string, replace it?

Oracle:
replace(name,'http://attribute?id=' [http://attribute?id='])

<div>
should have refreshed before posting the followup... &nbsp;:(
</div>


should have refreshed before posting the followup...  :(

<div>
You can also use a substring function in either Oracle or SQL Server<br />
Oracle - substr(name,instr(name,&quot;=&quot;<wbr />) + 1)<br />
SQL Server - substring(name, charindex(&quot;=&quot;,name) + 1,len(name))
</div>


You can also use a substring function in either Oracle or SQL Server
Oracle - substr(name,instr(name,"=") + 1)
SQL Server - substring(name, charindex("=",name) + 1,len(name))

<div>
@awking: this would also remove elements in strings like '1=1'. So it may remove too much.
</div>


@awking: this would also remove elements in strings like '1=1'. So it may remove too much.

<div>
<pre><code id="code-20-42654067-1">select ID, replace(Name, 'http://attribute?id=', '') Name from &lt;your_table&gt;</code></pre>
</div>


select ID, replace(Name, 'http://attribute?id=', '') Name from <your_table>

<div>
@Alex,<br />
<br />
Replace has already been suggested. &nbsp;Did we miss something?
</div>


@Alex,

Replace has already been suggested.  Did we miss something?

<div>
<blockquote>
need help with a SQL select
</blockquote>
It was just for the sake of completeness as he asked for a &quot;SELECT&quot; ;-)
</div>


> need help with a SQL select

It was just for the sake of completeness as he asked for a "SELECT" ;-)

<div>
<div class="content wysiwyg-content">
I need help with a SQL select that will remove a static value from a column value. &nbsp;<br />
<br />
ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Name<br />
123 &nbsp; &nbsp; &nbsp; &nbsp;<a href="http://attribute?id=eco_123" rel="ugc">http://attribute?id=eco_123</a><br />
233 &nbsp; &nbsp; &nbsp; &nbsp;<a href="http://attribute?id=eco_444" rel="ugc">http://attribute?id=eco_444</a><br />
<br />
Expected results<br />
ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Name<br />
123 &nbsp; &nbsp; &nbsp; &nbsp;eco_123<br />
233 &nbsp; &nbsp; &nbsp; &nbsp;eco_444<br />
<br />
I just want to remove &quot;<a href="http://attribute?id=" rel="ugc">http://attribute?id=</a>&quot;&nbsp;value from NAME column.
</div>
</div>


I need help with a SQL select that will remove a static value from a column value.  

ID           Name
123        http://attribute?id=eco_123
233        http://attribute?id=eco_444

Expected results
ID           Name
123        eco_123
233        eco_444

I just want to remove "http://attribute?id=" value from NAME column.

SQL Select - Remove Value

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.