Posted by Ed Murphy on 07/19/07 00:48

Hugo Kornelis wrote:

> On Wed, 18 Jul 2007 10:56:05 -0700, simonshang@gmail.com wrote:
>
>> I want delete the symbol "-" in the row "NIF". eg. A-1234 change to
>> A1234, D-453-DF to D453DF
>
> Hi Simon,
>
> SELECT REPLACE(NIF, '-', '')
> FROM YourTable;

Or, if you want to change the data in the table (not just the
data in your query output):

UPDATE YourTable
SET NIF = REPLACE(NIF, '-', '')

• Next in forum: default value being a concatenation of other columns
• Prev in forum: Simulating the Sql-99 OLAP window for running sums in S2005
• Thread view: Re: How write this sentence with T-SQL

[Reply to this message]