RE: Createquery and numbers that are strings

2006-03-10 Thread PINE Phyo Z
riday, March 10, 2006 10:40 AM To: CF-Talk Subject: Re: Createquery and numbers that are strings I could try putting an empty string in front, but even if that works I would still have to take out the empty space later because I still need the ssn for the primary key of the structure. The SSN i

Re: Createquery and numbers that are strings

2006-03-10 Thread Robert Everland III
I could try putting an empty string in front, but even if that works I would still have to take out the empty space later because I still need the ssn for the primary key of the structure. The SSN is returned as a string. Bob ~~~

RE: Createquery and numbers that are strings

2006-03-10 Thread PINE Phyo Z
0, 2006 10:01 AM To: CF-Talk Subject: Createquery and numbers that are strings I am creating a huge structure so that I can get data from many different tables that I can't join (don't ask long story). The key of my structure is a SSN, now I need to order the records to be in alphabe

Createquery and numbers that are strings

2006-03-10 Thread Robert Everland III
I am creating a huge structure so that I can get data from many different tables that I can't join (don't ask long story). The key of my structure is a SSN, now I need to order the records to be in alphabetical on the name, i can't use the name as the key since some people could potentially have