Feb 4, 2005 #1 Jimuniguy Technical User Mar 6, 2002 363 GB Hello, I have about 100 entrys where i have missed one field (the same one) which i need to fill. How can i go about filling this field? Thanks Jim
Hello, I have about 100 entrys where i have missed one field (the same one) which i need to fill. How can i go about filling this field? Thanks Jim
Feb 4, 2005 #2 r937 Technical User Jun 30, 2002 8,847 CA update thetable set thefield = 'foo' where thefield is null or thefield = '' rudy | r937.com | Ask the Expert | Premium SQL Articles SQL for Database-Driven Web Sites (next course starts March 6 2005) Upvote 0 Downvote
update thetable set thefield = 'foo' where thefield is null or thefield = '' rudy | r937.com | Ask the Expert | Premium SQL Articles SQL for Database-Driven Web Sites (next course starts March 6 2005)