Re: trouble converting a sql statement

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>>