Posted by Hugo Kornelis on 07/18/07 19:26

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;

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

• Next in forum: Re: Relationships error, C# Visual Studio 2005 database bug?, "the columns in table XYZ do not match an existing primary key or UNIQUE constraint", copying columns
• Prev in forum: Re: Combining many records into 1
• Thread view: Re: How write this sentence with T-SQL

[Reply to this message]