Home Forums SQL Server 7,2000 T-SQL Error converting data type nvarchar to float RE: Error converting data type nvarchar to float

  • converting a char to a float will only work if the char string is in fact a valid number.

    declare @string1 char(20), @string2 float

    set @string1 = '15,76' -- THIS WILL FAIL

    --set @string1 = '15.76' -- THIS WILL WORK

    print @string1

    set @string2 = convert(float,@string1)

    print @string2