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 the same name. So I came up with a way to loop through the key and get the name and put them into a query I create (you still with me). Now I do a dump of that query and it loses any 0's in front and treats it as a number. Even when I use javacast. The only way I have found to get by this is to put a letter in front of the SSN. Anyone have another solution to this?
Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235074 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54