I would like to extract few string values from a particular field in the table.
Order lines table contains a field Stock Code. This code is 30 digits long however, I would like to extract only 1-5 digits from it.
I read somewhere, someone asked this before but I cannot find her thread anymore.
It should be similar to my SQL code: (See last line of 7-889)
Select Unique Order_header.order_no,date_entered from order_header,order_lines where date_entered between "01/06/2008" and "30/06/2008"and order_header.order_no=order_lines.order_no and order_lines.stock_code[1,5]="7-889"
any ideas how to extract digits/string values from a field?