I have a string that looks like this:
NOTE - 2 PIECES REQUIRED #02021336173R0 1.50 X 83.25 QTY=2
I need to find the position where there is a " X " and then get the number before this position. So in this case I need to extract 1.50
How would I do this in t-sql?