Home Forums Programming General Extract values from varchar column RE: Extract values from varchar column

  • Sorry, I forgot to specify I only need the units and the amounts. ie

    comments:

    5321063 HOLLAND BL 90X210 10 Unts $7.27 Unt

    5321070 HOLLAND BL 90X210 1 Unts $7.27 Unt

    5321124 HOLLAND BL 120X210 13 Unts $8.64 Unt

    my 2 new fields should be :

    Units UnitPrice

    10 $7.27

    1 $7.27

    13 $8.64