SQL Server doesn't allow you to change the size of an existing field.
You have to re-create the table. 11 is pretty big. Usually DNIS
only includes a portion of the number and not the whole number itself.
I'll change the DB layout to be 12. DNIS is the number the user dialed
and Caller-ID is the number of the calling user.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com