Re: how to select and join on substring

[Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>]

its character 10 field

On Wed, Oct 29, 2014 at 5:30 PM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

> ok then also how to do on the view select
> i want to select the field mdordr first 8 only.
>
>
>                        Specify CREATE VIEW
> Statement
>
>
> ype subselect information.  Press F4 for a
> list.
>
>
>  FROM files . . . . . . .
> SHP4VAR27F.MFD1MD
>
>
>  SELECT fields  . . . . .   concat digits(MDORDR 8),
> MDAWGT
>
>
>  WHERE conditions . . .
> .
>
> On Wed, Oct 29, 2014 at 4:18 PM, Alan Shore <ashore@xxxxxxxx> wrote:
>
> > Assuming that the 10 digit order number is numeric
> > Try the following
> > Where '01' concat digits(order8) = digits(order10)
> >
> > Digits makes the numeric into alpha, with any leading zeroes
> >
> > Alan Shore
> > E-mail : ASHORE@xxxxxxxx
> > Phone [O] : (631) 200-5019
> > Phone [C] : (631) 880-8640
> > 'If you're going through hell, keep going.'
> > Winston Churchill
> >
> > -----Original Message-----
> > From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> > Hoteltravelfundotcom
> > Sent: Wednesday, October 29, 2014 4:16 PM
> > To: Midrange Systems Technical Discussion
> > Subject: how to select and join on substring
> >
> > I have to create a view - our order#s are 8 position, numeric.
> >
> > we use varsity ship package, there the order# is 10. they add usually '01'
> > right most
> >
> > Can I select records
> >  joining File8 to File10
> >
> > where order8 = (order10, 8 )   =left(order10,8)
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> > unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> > moment to review the archives at http://archive.midrange.com/midrange-l.
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.