Home Forums Data Warehousing Data Transformation Services (DTS) How to Convert from Varchar to Decimal RE: How to Convert from Varchar to Decimal

  • October 5, 2005 at 1:09 pm

    #595245

    Can you show some of the data?

    I think I could have given you a better query earlier.  Try:

    SELECT * FROM tableA WHERE ISNULL (FieldNameA, '') = '' OR ISNULL (FieldNameA, '') NOT LIKE REPLICATE ('[0-9]', LEN (FieldNameA))