View Single Post
  #2 (permalink)  
Old 03-16-2008, 10:30 AM
thindenim's Avatar
thindenim thindenim is offline
WebProWorld Pro
 

Join Date: Jan 2007
Location: Scotland
Posts: 238
thindenim RepRank 1
Default Re: DISTINCT Query probs

I may be reading the above wrong, but would the following not do the trick?

UPDATE Assign SET SalesRep = 'blah' WHERE SalesRep = NULL AND ZipCode = x;
__________________
Girlz Night - professional hair and beauty products
Web design glasgow - from Thin Denim
Reply With Quote