Updating a numeric field with a character field - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Updating a numeric field with a character field

Message

From

29/10/2014 10:23:21

Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada

To

29/10/2014 10:18:16

Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Updating a numeric field with a character field

Environment versions

SQL Server:

SQL Server 2012

Application:

Web

Miscellaneous

Thread ID:

01610090

Message ID:

01610092

Views:

31

I would have assumed this would work but it is not:

UPDATE Client SET Amount2=CAST(Amount AS Numeric(3))

Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52

Click here to load this message in the networking platform