sql - How do I select field first 8 positions only in a view -

sql - How do I select field first 8 positions only in a view -

how select order field (mdordr) first 8 positions in view ?

i need have view give me order number (mdordr) first 8 positions. varsity shipping systems adds 2 positions number create 10 long, (for numbr of cartons per order). how give me in view first 8 along weight column.

specify create view statement

ype subselect information. press f4 list. files . . . . . . . shp4var27f.mfd1md select fields . . . . . concat digits(mdordr 8), mdawgt conditions . . . .

is want?

select left(mdordr, 8) first8, mdawgt files conditions;

sql ibm-midrange db2400