[sam.adams61]

I've followed the instructions of a text book and when I tried to execute the following script I got a message saying: 'Cannot convert a char value to money. The char value has incorrect syntax.'

DECLARE @dataType VARCHAR(10)
SET @dataType = '58.00'
UPDATE ProductDetails.Products
	SET CostPrice = @dataType
WHERE ProductCode = 'S502S'

Any helpful advice would be greatly appreciated.

[no2pencil]

It would be helpful to know which Database this is to be used for.

[sam.adams61]

no2pencil, on 7 Apr, 2009 - 01:47 AM, said:

It would be helpful to know which Database this is to be used for.

MS Sql Server 2008 Express, and I'm not deliberately attempting to enter a wrong data type. The figure '58.00' is to be inserted into a column containing the money data type.

[F!st!cuffs]

It needs to be of the same data type to enter it in. Change varchar to whatever type CostPrice is.

[sam.adams61]

F!st!cuffs, on 7 Apr, 2009 - 01:54 AM, said:

It needs to be of the same data type to enter it in. Change varchar to whatever type CostPrice is.

Still getting the same message...I changed varchar to money, which is the data type of CostPrice.
Thank you for your input.

[PsychoCoder]

So the following code is giving you the error?

DECLARE @dataType MONEY
SET @dataType = $58.00
UPDATE ProductDetails.Products
	SET CostPrice = @dataType
WHERE ProductCode = 'S502S'

[sam.adams61]

PsychoCoder, on 7 Apr, 2009 - 03:25 AM, said:

So the following code is giving you the error?

DECLARE @dataType MONEY
SET @dataType = $58.00
UPDATE ProductDetails.Products
	SET CostPrice = @dataType
WHERE ProductCode = 'S502S'

Yep, any ideas why? Would greatly appreciate your advice. The same message appears...even by using the dollar sign.

[kzimmerm]

sam.adams61, on 6 Apr, 2009 - 08:37 PM, said:

PsychoCoder, on 7 Apr, 2009 - 03:25 AM, said:

So the following code is giving you the error?

DECLARE @dataType MONEY
SET @dataType = $58.00
UPDATE ProductDetails.Products
	SET CostPrice = @dataType
WHERE ProductCode = 'S502S'

Yep, any ideas why? Would greatly appreciate your advice. The same message appears...even by using the dollar sign.

The problem is the dollar sign in the SET statement. It should read

SET @dataType = 58.00

The MONEY data type handles the penny rounding which is unique to money and not NUMERIC or FLOAT.

Hope this helps.
Kurt