pulling multiple numbers out of a string

  • tpd1989

    Valued Member

    Points: 62

    I need help pulling multiple number values out of a string

    field name is Details and here are some examples of the values

    DETAILS

    Maximum width is 13'2", maximum length is 30'. Minimum total size for all custom rugs is 25 sq/ft.

    Maximum width is 15', maximum length is 25'. Minimum total size for all custom rugs is 25 sq/ft.

    Maximum width is 12', maximum length is 30'. Minimum total size for all custom rugs is 15 sq/ft.

    i need so get the number values pulled out and into their own fields, and the numbers aren't always the same

     

    here are two hopeful outputs

    thanks in advance!

  • Jonathan AC Roberts

    SSCoach

    Points: 17210

    Is it really SQL 7, 2000 you are using?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply