• Carla, the first thing I see is that unless your table only has one column, if you don't supply the column name into which you would like to insert the values, you will get an error like this

    Server: Msg 213, Level 16, State 4, Line 1

    Insert Error: Column name or number of supplied values does not match table definition.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.