I have a table that has a Name column with stuff like "$25 Gift Card".
I need to add another column to the table of type Number with the 25.
I was thinking of using VBscript but, not sure how to actually pull the name, split it and stuff the 25 into the same row.
There are about 140000 rows and possibly more depending.
Any ideas or pointers?