sql - How to select first section of order number -

sql - How to select first section of order number -

i want create view on table has order number length 10 digits. want first 8.

select pkgweight, order_num ylib.shipping date > 20140101

how want digits 1-8 on order_num?

left(order_num,8)

will homecoming first chars of string.

sql