Dear James,
   If your output phone number is numeric you do not need the single quotes.
From your code, it seems that you are still moving the phone num with spaces
on it.

Assuming that you want FinalNum to be moved to your output record,

The code will be like this... 
       PhoneNum = Trim(PhoneNum)  'This will take spaces at the beginning
and end of the string
       FinalNum = Left(PhoneNum, 4) & Mid(PhoneNum, 6, 7)
        Sql = "INSERT INTO MasterDoNotCall(PhoneNum) VALUES(" & FinalNum &
        ")"
I hope this helps.
                   -Regina

-----Original Message-----
From: James Texter [mailto:texter@o...]
Sent: Thursday, June 08, 2000 1:15 PM
To: professional vb
Subject: [pro_vb] RE: Size issue


Well, as much as I would love to do that, the problem is that they want the
number to be inserted with no spaces in between, so somewhere I have to trim
it out.  Do you think that is what is causing it to bog down?  If so, is
there a more efficient way to do it?  Any ideas as to why it creates such a
bloated database?

James

-----Original Message-----
From: Devia, Regina V [mailto:regina.devia@e...]
Sent: Thursday, June 08, 2000 10:51 AM
To: professional vb
Subject: [pro_vb] RE: Size issue


Dear James,
   Why don't you try this? (i.e. use FinalNum instead of PhoneNum)

 Sql = "INSERT INTO MasterDoNotCall(PhoneNum) VALUES('" & FinalNum &
"')"

                       -Regina