replicate('0',3-len(field_name))+field

how we can store the value like that 001,003,023 etc in sql
server 2005

Question Posted / sandeep modapathi

Answer Posted / sandeep modapathi

replicate('0',3-len(field_name))+field_name

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are sp_configure commands and set commands?

956

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

967

What is database replication? What are the different types of replication you can set up in sql server?

911

What is the difference between primary key and unique constraints?

901

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

955

Do you know sql server 2008 backup compression?

919

What is a scheduled job or what is a scheduled task?

910

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

892

Mention what are the different types of ssrs reports?

144

is it important for a database administrator to understand the operating system and file access? : Sql server administration

976

What is the name of the Database which IBM mainframe uses?

947

what are different types of raid configurations? : Sql server database administration

993

Why use “nolock” in sql server?

982

What is apply operator in sql?

956

Write a program using SQL queries to find a unique entry in a table.

940