[RESOLVED] Query won't run

Does anyone know why this query won't run? The fields fValue_xxx are all of the type 'nvarchar(50)'. It says that:

VB Code:

Server: Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to float.

on this query:

VB Code:

UPDATE tBSC 
SET fvalue_jan = '728,4',  
fvalue_feb = '769',  
fvalue_mrt = '912',  
fvalue_apr = null,  
fvalue_mei = null,  
fvalue_jun = null,  
fvalue_jul = null,  
fvalue_aug = null,  
fvalue_sep = null,  
fvalue_okt = null,  
fvalue_nov = null,  
fvalue_dec = null  
FROM tSBF_PI  WHERE lDepartmentID = 115 AND tSBF_PI.lPIID = 166 AND tSBF_PI.lSBF_PIID = tBSC.lSBF_PIID

When I remove the ',4' by fValue_jan, it works, otherwise it won't...

Anyone?

Re: Query won't run

Got it, query should replace the ',' by a '.' if the value is a float. Looks like a bug in SQL2K

Re: [RESOLVED] Query won't run

It would depend on whether SQL Server recognizes localizations, and whether the computer this is running on is localized to use ',' as the decimal separator.