Store it in a varchar field.

What if the number is 0800 COFFEE?

If its varchar it can save telephone numbers in all formats.

Regards

   Anton

Either I am misunderstanding the question or something, but I disagree with the answer.

The correct answer should be a syntax error,as the programer produced a result that he (or she)...

Hi, this is not to difficult if the numbers are only in the front.

~~begin Sample~~

Create table #temp (value varchar(20))

Insert into #Temp (value) values ('15')

Insert into #Temp (value) values ('15B')

Insert into...

In SQL 2000 "dynamic SQL" is not recompiled every time, but rather cached in on the server.

From MSDN:

When SQL Server receives a call to sp_executesql, it automatically checks the...

The example will work well for Intranet sites, but would become a security risk for Internet Sites.

Reason:

From the article; "....Note that the value attribute contains the primary key value of...