I need a simple way to convert a character to a int in the order by clause.
I do not want to change the datatype of the table.
for example:
This is how I would do it in SQL Server:

I am using free table and I insert some data from asp file.
My questions are:
1--Is there a way to use    prg (foxpro program) file like           store
procedures.(send and retreive data from                 asp files)

I use an articles-table containing about 400.000 articles that is made in a
special way. I receive an Excel-file that contains the latest article-prices,
id-numbers etc. This file is then imported into an access-database to make it
fit into the file structure I use in Foxpro and ...

since inlist() is an optimizable function, it would have been great if it
could work both ways as follows:-
eg:
currently SELECT * FROM mydbf WHERE INLIST(fld,'01') searches for records

i have to run a SQL command using the $ sign as shown below:
SELECT * from <dbf> WHERE '01' $ fldname
The VFP help says using $ the SQL is not optimizable.
Is there any other alternative to using $.

When running a SQLEXEC call to an Oracle database, its returning the
following "results"
"Connectivity error: [Microsoft][ODBC driver for Oracle]Cannot bind PL/SQL
Records or Cursor References"

I'm trying to use the upsizing wizard to export my VFP8 database tables to a
MYSQL database held on our LAN.
I have an ODBC connection to the database and can read / write records from
a a simple test table no problem.

Can someone help me with this.
I run a SELECT -SQL in VFP 8 and depending on what information I ask for,
the program will terminate as soon as I get a record set.
I get the window that asks me if I want to send the error report to MS or

I was hoping there may be an easier way of implementing optional join
conditions in a SELECT statement.
The scenario is that I have a number of fields that are optional at run time
i.e. Index_value_1 = 0 (any value will do) or Index_value_1 = 643 (only

I encounter a serious problem converting from VFP7 to VFP9. A local view in
VFP7 using a "LIKE" clause works like lightning... (I checked that Rushmore
is on). In VFP9 the same view is dead slow, Rushmore is off, codepages match
(CPDBF and CPCURRENT)... The table the view works ...

Since switching to VFP 9.0 the following SQL won't run and is giving a
'Group By' error.
Sele isitm, abc, isuom, islocn, Sum(r2tqty*.0001) As qtysold, ;
SUM(r2tqty*.0001)/umcnv1 As buyqty, imuom3 As buyum, lmsty1 As ldg, ;