The CallerID column that you presently have might the wrong type. From
ISQL, type "sp_help calls" to find out what type it presently is. If it's
already set to varchar, then there's probably nothing wrong in the db. Test
it by typing the following in ISQL: "select distinct callerid from calls").
If the results show nothing more than "null", it sounds as if your NAS may
not be sending the info. If you have all sorts of numbers showing up, then
your db is fine, but your Online stored procedure might be out of date.
If the type is NOT presently varchar, you can probably change the type from
whatever it is to varchar via Enterprise Manager IF you are using SQL 7. If
you're using SQL 6.5, you'll have to rename CallerID to CallerIDOld (or
whatever), then add the new CallerID column to the table like you mentioned
before (or via Enterprise Manager).
For more information about this list (including removal) go to: