I need someone versed in VFP 6.0 SQL synatx.

This query works fine and does as expected...
UPDATE CT ;
SET CT.SID = "JS" ;
WHERE CT.SID = "JA"
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
This query updates cells with "JP" but also cells with "JPS"...
UPDATE CT ;
SET CT.SID = "JS" ;
WHERE CT.SID = "JP"
...is there a wildcard in this I'm not seeing?
How do I only update "JP" and leave "JPS" as is?

thanks

I have bunch of excel files with 10-15 sheets in each file. I would like to
import all data from each sheet and each file to foxpro table. I can do it
with import wizard but it is too much for each sheet. I want to write
program which can read all data. something like select * from
excelfile1.sheet1, Is there anything like this?

I see. Thanks a lot for the information.

Anyway, I can still enforce the linking.

Patrick Tura

"Patrick Tura" wrote in message
news:CF407F79-D8C6-4022-BDF6-FC6C6C40C48E@microsoft.com...

I suspect the problem is the original table was in a database and the new one
isn't.

Fox can only have 10 letter field names in free tables.

Regards
Mark

I've got a table with a column of telephone numbers that have been
called, and a tariff table with tariff codes and the number that
those tariffs apply to.

The number in the tariff table is the first some number of digits of
telephone numbers.

I want to pull out the relevant tariff code for each telephone number
called.

I'd'a thought that should be easy, but damned if I can get it to
work. Can anyone help me out on this one please.

Regards
Mark

brand cialis for order in Avola http how to buy cialis online.gaia.com blog best price for sildenafil generic cialis cialis lung disease cialis 2 day delivery

+++ MEN'S HEALTH +++ MEN'S HEALTH +++ MEN'S HEALTH +++
+
BUY CHEAP CIALIS - ORDER CIALIS ONLINE (ALL CARDS ACCEPTED !!!)
http://jhku.net/ACHETER-CIALIS-BON-MARCHE/
http://jhku.net/ACHETER-CIALIS-SOFT/...

vigara denver in Westree half price cialis medical prescription cialis cialis pills online buy cialis online without prescription

+++ MEN'S HEALTH +++ MEN'S HEALTH +++ MEN'S HEALTH +++
+
BUY CHEAP CIALIS - ORDER CIALIS ONLINE (ALL CARDS ACCEPTED !!!)
http://jhku.net/ACHETER-CIALIS-BON-MARCHE/
http://jhku.net/ACHETER-CIALIS-SOFT/...

kredit online beantragen kredit kredit ohne schufa in kredite zinsen kredit trotz schufa und ohne

+
+
+++ GUENSTIGE KREDITE ONLINE +++ KREDITE IM INTERNET OHNE SCHUFA +++
+
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
+
+
+
+

detektiv in frankfurt gehalt frankfurt hunter detektei detektei den privatdetektiv

viagra prescription online Brazil impotence picture pill viagra cheap levitra viagra href foro forum viagra vs buy viagra levitra alternative lavitra

+++ MEN'S HEALTH +++ MEN'S HEALTH +++ MEN'S HEALTH +++
+
BUY CHEAP CIALIS - ORDER CIALIS ONLINE (ALL CARDS ACCEPTED !!!)
http://jhku.net/ACHETER-CIALIS-BON-MARCHE/
http://jhku.net/ACHETER-CIALIS-SOFT/...