Determine if the Field Contains a Specific Character
I can not Get this in my Head. I have a Field that Contains A Value Similar to This
Of Course the 2x can be 100x and the $5.99 Can be $100.99 I Want to Look at this Field and If The Data in this Field looks Like this, I want to be able to Select the 2 (or Whatever it is) and Copy it to a Feild in another table
If I Use Left() it is only Vaild when It equals exactly what I use, Im not getting how to Look at Just the x, Then Select the Number directly to The Left of it..
Again My Problem is How I Determine that This is the Field I want to Select from.