Professional Web Applications Themes

Replace .0 - Microsoft SQL / MS SQL Server

I have imported some data form XL that seems to have attached .0 to each INT .... is there a way I can replace this .0 with nothing?...

Sponsored Links
  1. #1

    Default Replace .0

    I have imported some data form XL that seems to have attached .0 to each INT
    .... is there a way I can replace this .0 with nothing?


    Sponsored Links
    John McDermidt Guest

  2. #2

    Default Re: Replace .0

    Woops. Posted the same question twice ...

    "John McDermidt" <jmcdt73_at_msn.com> wrote in message
    news:ed6RCzlRDHA.1324TK2MSFTNGP11.phx.gbl...
    > I have imported some data form XL that seems to have attached .0 to each
    INT
    > ... is there a way I can replace this .0 with nothing?
    >
    >

    John McDermidt Guest

  3. #3

    Default Re: Replace .0

    Ahhhhhhhhh. thanks :)
    "Vishal Parkar" <vgparkarhotmail.com> wrote in message
    news:uzhRESmRDHA.1324TK2MSFTNGP11.phx.gbl...
    > while importing the data using DTS after specifying source and destination
    > you will get a screen "select source tables and views" here click on
    > "Transform". a new window will open , click on "Edit SQL" here you can
    > specify the table definition change the datatype to numeric(it might be
    > float)
    >
    > --
    > --Vishal
    >
    > "John McDermidt" <jmcdt73_at_msn.com> wrote in message
    > news:ed6RCzlRDHA.1324TK2MSFTNGP11.phx.gbl...
    > > I have imported some data form XL that seems to have attached .0 to each
    > INT
    > > ... is there a way I can replace this .0 with nothing?
    > >
    > >
    >
    >

    John McDermidt Guest

Similar Threads

  1. Replace XML
    By Cloudesk in forum Macromedia Flex General Discussion
    Replies: 3
    Last Post: April 29th, 03:39 AM
  2. help with the replace(pattern, replace)
    By Cloudesk in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: April 24th, 03:22 PM
  3. Search and replace (super global replace)
    By johnweiffenbach@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 1
    Last Post: April 8th, 08:56 AM
  4. SQL Replace
    By Chopper in forum ASP Database
    Replies: 4
    Last Post: October 28th, 08:05 PM
  5. Replace in ASP/VBS/SQL
    By Pret Orian in forum ASP
    Replies: 17
    Last Post: July 10th, 02:11 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139