I was wondering if it possible to use an expression in a query to split one column in a table into two seperate columns. Column X is Description and looks like this, for example....
2,500 @ $21.55. The @ symbol is always present so I essentially want to wind up with two columns Quantity (2,500) and Price @21.55
Thanks in advance for any help.