How to convert data

    Date: 05/17/06 (SQL Server)    Keywords: no keywords

    I have a data in the field looks like N 4390-1524-23
    How can I convert them to look like N 4390152423?

    Thank you in advance.

    Elena.

    Source: http://community.livejournal.com/sqlserver/48343.html

« DTS and fixed length txt file || Software already installed?... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home