Home Forums SQL Server 7,2000 T-SQL Linking "text" item with "numeric" item -- Please HELP ! RE: Linking "text" item with "numeric" item -- Please HELP !

  • June 11, 2004 at 7:02 am

    #510035

    Use cast to convert text to int/numeric

    OFFERITEMS ON ITEMMAST.EDPNO = CAST(SUBSTRING(OFFERITEMS.OFFERITEM, 9, 8) as int)

    Far away is close at hand in the images of elsewhere.
    Anon.