Home Forums SQL Server 7,2000 General how getting numbers with 2 digits behind , RE: how getting numbers with 2 digits behind ,

  • March 18, 2004 at 6:35 am

    #499306

    What wizard? How do you want to store the values. Are they numbers (some locales use comma instead of full stop as decimal separator).

    If you want to store the values as decimal (numeric) then convert the commas to full stops as in

    DECLARE @test-2 numeric(9,2)

    SELECT @test-2 = REPLACE('1,111' , ',' , '.')

    SELECT @test-2

    Far away is close at hand in the images of elsewhere.
    Anon.