Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. articles. downloads. faq. members. files. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: naveed shahid
  Where is naveed shahid?
 
 Pakistan
 naveed shahid
Subject: RE: problem with strings
Thread ID: 103457 Message ID: 103490 # Views: 1 # Ratings: 1
Version: Visual FoxPro 7 Category: General VFP Topics
Date: Friday, August 4, 2006 3:11:16 PM         
   



Did the fields has equal length in both tables?
This gives me right result:
CREATE CURSOR Table1 (phyto_cert Char(50))
CREATE CURSOR Table2 (phyto_cert Char(50))

INSERT INTO Table1 VALUES('PCKS/33857/-06-07')
INSERT INTO Table1 VALUES('PCKS/33858/-06-07')
INSERT INTO Table1 VALUES('PCKS/790/06-07')
INSERT INTO Table1 VALUES('PCKS/1381/06-07')
INSERT INTO Table1 VALUES('PCKS/1487/06-07')
INSERT INTO Table1 VALUES('PCKS/2032/06-07')
INSERT INTO Table1 VALUES('PCKS/306/-06-07')
INSERT INTO Table1 VALUES('PCKS/308/-06-07')

INSERT INTO Table2 VALUES('PCKS/33857/-06-07')
INSERT INTO Table2 VALUES('PCKS/33858/-06-07')
INSERT INTO Table2 VALUES('PCKS/790/06-07')
INSERT INTO Table2 VALUES('PCKS/1381/06-07')
INSERT INTO Table2 VALUES('PCKS/1487/06-07')
INSERT INTO Table2 VALUES('PCKS/2032/06-07')
INSERT INTO Table2 VALUES('PCKS/306/-06-07')
INSERT INTO Table2 VALUES('PCKS/308/-06-07')
INSERT INTO Table2 VALUES('PCKS/01/790/06-07')
INSERT INTO Table2 VALUES('PCKS/01/1381/06-07')
INSERT INTO Table2 VALUES('PCKS/01/1487/06-07')
INSERT INTO Table2 VALUES('PCKS/01/2032/06-07')

 SELECT table1.*;
        from table1;
  INNER JOIN Table2 ON UPPER(table1.phyto_cert) = UPPER(table2.phyto_cert);
INTO CURSOR crs
BROW NORMAL


ENTIRE THREAD

problem with strings Posted by naveed shahid @ 8/4/2006 11:43:05 AM
RE: problem with strings Posted by Borislav Borissov @ 8/4/2006 12:00:58 PM
RE: problem with strings Posted by Ken Murphy @ 8/4/2006 12:34:22 PM
RE: problem with strings Posted by Borislav Borissov @ 8/4/2006 1:59:23 PM
RE: problem with strings Posted by Ken Murphy @ 8/4/2006 2:58:52 PM
RE: problem with strings Posted by naveed shahid @ 8/4/2006 3:04:47 PM
RE: problem with strings Posted by Borislav Borissov @ 8/4/2006 3:11:16 PM
RE: problem with strings Posted by naveed shahid @ 8/5/2006 2:00:30 PM
RE: problem with strings Posted by Tamar Granor @ 8/7/2006 10:58:36 PM
RE: problem with strings Posted by Ken Murphy @ 8/4/2006 3:12:35 PM
RE: problem with strings Posted by Borislav Borissov @ 8/4/2006 3:18:40 PM
RE: problem with strings Posted by Ken Murphy @ 8/4/2006 3:23:15 PM
RE: problem with strings Posted by Pete Sass @ 8/4/2006 8:01:21 PM
RE: problem with strings Posted by Ken Murphy @ 8/4/2006 8:17:37 PM