Originally posted by Peakuser
I've created a new column in a table with over 5000 records and i'm trying to place the exact same text in each of the blank fields for all the records. How can this be done? It's driving me mad.
SQLString="UPDATE MyTableName SET MyNewColumn=SomeNumber;"
SQLString="UPDATE MyTableName SET MyNewColumn='Some string';"
Or ... Take your pick on the appropriate data type ...