How to change the format of a auto generated ID column

Question

Hi Can anyone tell me How to change the format of a auto generated ID column in Sql server as if ID is 1 i want to make it 001-01 2 to 002-01 3 to 003-01 ...so on. but i want this in Select Query without creating any column for this format. and if my ID is 10 digit ?means if My ID is 12456 then is it make any reflect ?actually if my ID is 1 or 2 digit then i want to add 0 otherwise not. Any help will be appreciated. Thanks in advance Smile |

Saroj Kumar Sahu · Answer

Hi  Thanks for ur reply..this one also partially correct.and here is the correct one. select case when LEN(ID) from Table

Sanjeeb Lenka · Answer

try this query SELECT (RIGHT('00'+ID3)+ '-01') as ID form yourtablename

Saroj Kumar Sahu · Answer

Hi Thanks for reply..i tried this but not working..

Sanjeeb Lenka · Answer

try this query: SELECT RIGHT('000000000'+ID10) as ID from yourtablename or SELECT RIGHT(replicate('0'9)+ID 10) as ID from yourtablename ID: your column name yourtablename: your table name mark it as answered if it helps you