Home Forums Article Discussions Article Discussions by Author Discuss content posted by brewmanz Extracting a Numeric Reference from a VARCHAR field RE: Extracting a Numeric Reference from a VARCHAR field

  • November 20, 2008 at 7:19 am

    #901031

    Additionally,

    1. It doesn't properly support a legitimate value of -1 as -1 is being used to indicate that the value is not numeric.

    2. An explicit CAST is needed in the assignment part ("THEN") of the CASE statement as for some quirky reason, a value of '123.45' cannot be implicitly converted to DECIMAL(38,19) when it is part of a CASE statement. Error: Conversion failed when converting the varchar value '123.45' to data type int. Yet a direct assignment (IntRef = ExtRef) works fine! (SQL Server 2005 SP2)

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]