February 13, 2003 at 9:20 am
Hello guys:
We have a SQL 7 srvc pack 4/Win NT 5.0 srvc pack 3 and a query like this:
"select convert(float, pm_valor) from ger_pm
where pm_id = 'PM_PRPIS'"
where pm_valor is a varchar column, return this message:
Server: Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to float.
In another box, we have a SQL 2K srvc pack 3 in a Win2K srcv pack 3, and this query work fine.
In a SQL 7 srvc pack 4/Win NT 4.0 srvc pack 6a, this query works, too !
Can anyone help me,
TIA,
Aldair.
February 13, 2003 at 6:44 pm
Try
"Select pm_valor from ger_pm
where pm_id = 'PM_PRPIS' And IsNumeric(pm_valor)=0"
February 13, 2003 at 6:44 pm
Try
"Select convert(float, pm_valor) from ger_pm
where pm_id = 'PM_PRPIS' And IsNumeric(pm_valor)=0"
February 14, 2003 at 11:00 am
Thank you for your tip, but the error is the same:
Server: Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to float.
I think that this behavior of SQL 7 is due to the Regional options settings, what do you think about this ?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply