Hi all.

I have a problem using SQL sentence.

Cursor csr1 is as below and resulted from ORACLE Remote view

c1 (char 5) c2 (char 5) (&& both fields were
----------- ----------- && varchar type in '0.234' '0.5' && ORACLE DB.
'0.2' '0.5'

Now I want to subquery from the cursor Csr1 manupulating fields.

Select c1 + ' * ' + c2 AS SPEC FROM csr1 INTO CURSOR csr2

csr2 returned as below.
SPEC
--------
0.234 *0.5 (&& NOTE the position of
0.2 *0.5 Asterisk mark * )
But I want the result to be ordered like this..
SPEC
--------
0.234 * 0.5
0.2 * 0.5

Does anyone know how ? I think I've tried every possible way I could
using PAD related funtion.

Is it possible to use PAD function in VFP SQL function ? I guess this
would be a same kind of problem using calculation function in SQL.
Say,
SELECT MyTable
CALCULATE var( field1 ) INTO .... is OK.

But
'Select VAR( field1 ) from myTable' seems not to work .

Am I misunderstood ?

T.I.A