IT Manager

Vinny Johnson

<div>
the database is mssql. &nbsp;the % may be anywhere in the first 60 characters and not all records will need to have the % replaced. adjusting the syntax a little works!! 
 
&nbsp; replace(substring(mycol,1,60),'%','-') &nbsp;+ substring(mycol,61,61) 
 
Thank you!!
</div>

the database is mssql.  the % may be anywhere in the first 60 characters and not all records will need to have the % replaced. adjusting the syntax a little works!!

  replace(substring(mycol,1,60),'%','-')  + substring(mycol,61,61)

Thank you!!

<div>
<div class="content wysiwyg-content">
I have a long string and need to replace a &quot;%&quot; with a &quot;-&quot; but only if the &quot;%&quot; is within the first 60 characters. 
 
Example input 
recording-20181012_183357-7205756104-0-141850%252317199648923-0-HVDA-callhalf-15475983977%3A0_%5BcallingPartyNumber%5D.wav 
 
example output 
recording-20181012_183357-7205756104-0-141850-252317199648923-0-HVDA-callhalf-15475983977%3A0_%5BcallingPartyNumber%5D.wav
</div>
</div>

I have a long string and need to replace a "%" with a "-" but only if the "%" is within the first 60 characters.

Example input
recording-20181012_183357-7205756104-0-141850%252317199648923-0-HVDA-callhalf-15475983977%3A0_%5BcallingPartyNumber%5D.wav

example output
recording-20181012_183357-7205756104-0-141850-252317199648923-0-HVDA-callhalf-15475983977%3A0_%5BcallingPartyNumber%5D.wav

SQL query to replace character if exists within first 60 characters

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.