The obvious work around will be assign a new variable and put the empty string + SSN. In that way, you don't need to take out the empty space from your structure. But depending on how you are going to use it, maintaining two variables instead of one might drive your mad.
So, the other option that I can think of right now is find out which table or query give you back the SSN as number and when you get the value use the NumberFormat(SSN, "000000000") and padded the zeros.. Regards, Pine -----Original Message----- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Friday, 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 is returned as a string. Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235084 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
