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

[Back to original message]