Results 1 to 2 of 2

Thread: help with field trim

  1. #1
    Join Date
    Oct 2011
    Posts
    1

    help with field trim

    i have a table with a column like this

    2dogs @ $200
    1@$5.00
    1@$25 dogs

    i need to trim everything out so I just end up with the dollar amount

    i.e.

    200.00
    5.00
    25.00

    thank you in advance for the help

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Can try substring along with charindex if it's on sql server, books online has details.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •