Michael Earl (4/17/2008)
Oh - and Matt - that's pretty slick.Hats off to you.
thanks - it works pretty well as long as you dont' have to say it ten times fast....that's quite the mouthful!!!!
By the way - in case you have duplicate phone numbers in your dataset...if you replace NEWID() with your existing phone number, this should generate the same random number for every duplicated instance....
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?