Skip to Content
0
Former Member
Aug 01, 2008 at 10:32 AM

Extract info from field

20 Views

Morning all,

I would like to extract few string values from a particular field in the table.

Example:

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?

many thanks

Kind regards

Jehanzeb