Post reply

Data Manipulation

  • September 7, 2010 at 2:17 pm

    #227442

    Hi,

    Im importing data from a Flat file using Bulk Insert. I have few rows in my Table which have numeric data in a column as ("222,332,363"), How can i convert this into (222332363). i.e remove the quotes and comma ?

    Thanks

  • September 7, 2010 at 2:48 pm

    #1217611

    Personally, I'd bulk insert into a staging table and then run on my insert to the real one a REPLACE( Column, ',', '') statement.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • September 7, 2010 at 4:09 pm

    #1217661

    Hi,

    Thank you very much ...It Worked.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply