alright my issue is I have a database 'D' with a table 'T' in this table i have a column 'C' all the entries in this column are set to Null but i need them to be set to 1 I can't seem to figure out how to make a query to do this as i have never played with sql queries before please someone help me out im so frustrated and to do it manually i would have to type down 1 over 200k times.
UPDATE T
SET C = '1'
WHERE C = ''
Don't know what goes in the quotes for where to signify null tried 0 and null and a couple other things don't even know if any of what i wrote is right as i dont know sql...
Edited by Gamer2bn, 12 November 2006 - 05:14 PM.