If you don't need to do it programatically, that might be the easiest way. If there are a bunch, and you just need it to be unlikely they line up, do a select then sort one or both columns using arraysort(). Maybe sort the last names ascending, and the first names descending. If you want them more "randomized" then sort the rows in the query by your PK, or some other column, then only sort either the first or last name column alphabetically.
--Ben Doom Will Tomlinson wrote: >> Better living through chemistry. >> >> What do you mean bu "scramble" data? Resort two columns so that they >> >> dont' line up anymore? > > Correctomundo! > > I have a first name column and last name column. > > I want to mismatch them so they don't line up anymore. > > I'm thinkin I may just export them to a spreadsheet, do it from there, then > import it back in. > > Will > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289014 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
