<div>
Not quite sure I understand. &nbsp;I think you want to replace a string value where you find a &quot;-&quot; with a space.<br />
<br />
What exact language do you need this in.<br />
<br />
SQL, asp.net....please tell me so I can provide the best syntax.<br />
<br />
<br />
<br />
Also.<br />
<br />
Provice the test strings that cover all scenarios.<br />
<br />
<br />
In SQL and in most modern programming languages we have a replace or string manipulation function.<br />
<br />
If it gets too crazy we can do pattern matching or even regex.<br />
<br />
So for 100% answer..please provide your 100% &nbsp;scenario.<br />
<br />
Also please provide if you want this to happen in code...versus database. &nbsp;We can do this several ways and in both places.<br />
<br />
Thanks,
</div>


Not quite sure I understand.  I think you want to replace a string value where you find a "-" with a space.

What exact language do you need this in.

SQL, asp.net....please tell me so I can provide the best syntax.



Also.

Provice the test strings that cover all scenarios.


In SQL and in most modern programming languages we have a replace or string manipulation function.

If it gets too crazy we can do pattern matching or even regex.

So for 100% answer..please provide your 100%  scenario.

Also please provide if you want this to happen in code...versus database.  We can do this several ways and in both places.

Thanks,

<div>
<div class="content wysiwyg-content">
I want to remove the '-' character and any spaces ' ' from a string. I am trying to do a double replace but my syntax seems icnorrect.<br />
This seems to work for replacing the '-' but I am not sure what the syntax will be to also remove the spaces<br />
<br />

<pre><code id="code-10-29044303-1">(Replace(a.fieldname,'-','') AS fieldnameclear)</code></pre>
</div>
</div>


I want to remove the '-' character and any spaces ' ' from a string. I am trying to do a double replace but my syntax seems icnorrect.
This seems to work for replacing the '-' but I am not sure what the syntax will be to also remove the spaces

(CODE)

replace syntax

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.

Web Development

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

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.