Can anyone help me?
I need to search for a word inside a field.
The problem is that I do not know where the word starts (begining,
middle, end)

I use a parameter driven view in my application to fetch and update records
from a table.
Under development and using files on my C drive my form opens and closes
very quickly (1 or 2 seconds).

How can I upsize a table without using the Upsizing wizard, i.e., using SQL
pass-through ?
My native dbf contains lots of fields and the resulting SQL commands exceed
255 characters.

I have a table that have records that can be grouped by an ID field.
In this table there are 4 groups of 25 records each.  So in the ID
field there are 4 unique ID values.  The records are randomly
distributed through out the table.

In VFP 8, I've created a remote view (using 'available data sources' to
an access mdb.
When I USE the view, I get a Select Database dialog box.
Is there any way to specify the required information, so that the dialog

Does anyone know if it's possible to combine these 3 SQL lines into one? I
have a feeling that there is, but I have no idea how. Any help would be
appreciated.
select branchcode, count(*) as ocount ;

I am experiencing some strange behaviour which I am hoping someone can
shed some light on.
I have a table which has a name field (character length 30). What I
want to do is get the last word in that fields using a select

How can I benefit from Rushmore Query Optimization in my SQL Queries?
Is there an optimized function instead of the '$' operator?
Thanks in advance
Noel

I have the following problem when I sent a recordset update with SPT
Tecnology.
nhandle = sqlstringconnect("DRIVER=SQL Server")
*!* I use SQLPASSthrouth