excluding specific characters from a field

Posted on 2005-05-12
Last Modified: 2010-03-19
I have a table witn say 1,000,000 records I want to exclide the character "." from the fields leaving no space.

in fixpro the idea would be replace all field with chrtran(field,".","")

Is is simple and fast, any equivalent in MS-SQL
Question by:robrodp
    1 Comment
    LVL 75

    Accepted Solution

    >>Is is simple and fast, any equivalent in MS-SQL<<
    It is simple, whether it is fast, will depend a great deal on the number of rows that need to be updated.

    Update TableName
    Set ColumnName = REPLACE(ColumnName, '.', '')
    Where CHARINDEX('.', ColumnName) > 0


    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now