Very Computer

1. SQL Server Constraint for Telephone Number

Greetings,

I'm a bit of a newbie at designing databases with SQL server 2000 and
I am struggling at the moment with constraints for fields.

I have an old database with a string telephone number field that i
want to import into a new database i'm designing. However, in the new
database i want the telephone number field to store only numbers.

At first i thought i could set it to a numeric format but that loses
the leading zeros of the phone number so i came up with the idea of
using a constraint. However, so far the best i've been able to manage
is to permit a limited number of digits in the field using the
following constraint expression entered via Enterprise Manager:

([Telephone] like '0-9')

This statement only allows me to enter one digit into the field. I'm
not sure how to set up the expression to allow as many numbers as the
field allows, but only digits between 0-9.

Any ideas on this or any other way to accomplish a non-string
telephone number?

Many thanks in advance,

James Currer

2. VFP GROUP : Very rough draft of Request For Discussion

3. Need help choosing a telephone prompting system

4. Uni-Data

5. Telephone Management Systems

6. which is the fastest ?

7. Telephone Reservation Systems

8. problem with transaction

9. SQL Server Remote Registration Failure from Window 98 to Windows 2000 Server

10. .NET SDK changed my SQL Server Registration Servers

11. SQL Server 2K Enterprise Evaluation - Local Server Registration

12. SQL Server 6.5 Server registration problem