Hi All,
I have one product table having the following field

pk_productID int,
descript nvarchar(50)

i want to format pk_productID field in the following number format
for example my product code will be
000001
000002

how i can achieve this task

Can somebody help meeee.....

I think you need to keep you column as varchar instead of int

urt

Help yourself by helping someone.

But in Msaccess we have an option called 'format' my doubt is , is ther any such format in sql server

Is it vital to have the actual data in the database have these padded values? Or is it a concern more for display of the data? Is the latter, in what type of application/code are you displaying the data?

-Peter
peterlanoie.blog

Yes... create a calculated column to display the data.

I have to agree with the others, though... storing formatted data in a table is "Death by SQL" and, no, this isn't Access.

--Jeff Moden

IF you want to display only once in a while, You can use it like this
SELECT RIGHT('000000'+CONVERT(varchar, pk_PRODUCTID), 6) AS ProductCode
Otherwise add an additional (Computed) column using the format. But it is not a recommended solution for a highly used production system.


G.R.Preethiviraj Kulasingham

SELECT RIGHT('000000'+CONVERT(varchar, pk_PRODUCTID), 6) AS ProductCode
or change the column data type varchar