SQL – Replace Statement

The Replace Statement replaces all instances of a specified string value with a new value.

Syntax:

      REPLACE(Field Name, Search String, New String)

      SQL Server:

      SELECT REPLACE(FIELD1,'/','-') FROM TABLE

      Oracle:

      SELECT REPLACE(FIELD1,'/','-') FROM TABLE;

#SQLServer #Oracle

Some words from the sponsors...

Add a C# Dropdown to a Bootstrap Modal Dialog

This example combines C# and Bootstrap to create a bootstrap modal dialog containing an asp dropdown and an asp button to retrieve...

Use C# to Populate Dropdown Lists With XML

The code below opens an xml file, reads the data from the xml file, dynamically adds a label for the dropdown list, and adds the dropdown list to the asp.net page...

Add Style Properties to ASP.Net Controls to Improve Appearance

The default formatting for ASP.Net controls is very dated. The default formatting is basically the same as the formatting in Visual Basic 1.0 ...

Export To A Text File From A DataGridView Control

Add a button control to Form1.
Add a DataGridView Control to Form1....