Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 1 as 0001

Author  Topic 

dass05555
Yak Posting Veteran

55 Posts

Posted - 2008-03-06 : 00:35:35
hi friends...
good morning,


i want to get the integer 1 as 0001 in a table,
is there any keyword for this...


------------------
id | cname
------------------
0001 | king
0002 | hall
0003 | jack
. | .
. | .
. | .
1000 | don

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-03-06 : 00:45:36
Do not cross post:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98522

CODO ERGO SUM
Go to Top of Page
   

- Advertisement -