Re: trouble converting a sql statement

[CRPence <CRPbottle@xxxxxxxxx>]

  FWiW whether a space is after a delimited literal, prior to a new 
clause of the SELECT, is of no concern to the SQL.

  However that there is no column named DESC and no column named 
TEEMES, both of those would be a problem :-)  Given the spurious comma 
is eliminated and the column reference TEEMES is changed to TEMEES [as 
shown in the /original SQL/ which presumably was functional], the SQL 
will work either way; with or without the extra space.  That is because 
the space is just whitespace to the SQL.

  Specifically either of the following works fine without error; albeit 
the latter is probably considered more readable by most:

    and TEMEES = 'FR'ORDER BY AGE DESC'

    and TEMEES = 'FR' ORDER BY AGE DESC'

Regards, Chuck

On 07 Mar 2013 12:42, DeLong, Eric wrote:
> Add a space....
>                                           /space before your order by clause...
>    'WHERE TEMEMP = TE1EMP and ' + STS + ' ORDER BY AGE,DESC';
>
> Smith, Mike on Thursday, March 07, 2013 2:23 PM wrote:
> > <<SNIP>>
> > This is the original SQL statement.
> > <<SNIP>>  WHERE TEMEMP = TE1EMP and TEMEES = 'FR' Order by age desc;
> >
> > <<SNIP>> Here is where I'm at now.
> > Select ;
> > When FPEMP = 'F' ;
> > Sts = 'TEEMES = ' + Q + 'FR' + Q;
> > When FPEMP = 'P' ;
> > Sts = 'TEEMES = ' + Q + 'PT' + Q;
> > EndSl ;
> >
> >    sqlstring =
> >   'select <<SNIP>>
> >    'WHERE TEMEMP = TE1EMP and ' + STS + 'ORDER BY AGE,DESC';
> > <<SNIP>>