Is there a command in SQL Server 2K 2

[snyderj]

Is there a command in SQL Server 2K similar to Excel's REPT command? I'm thinking of something such as:
'ABC' + REPT(0,10-LEN(@variable)) + @variable

so that ABC123 becomes ABC0000000123.

Thanks.

 

[bjd4jc]

I did this in the SQL Query Analyzer. It is not exactly the same but it does what you want.

Declare @Variable int

set @Variable=1234

Print Len(@Variable)

PRINT STUFF('ABC' + cast(@variable As Varchar(10)), Len('ABC')+1, 0, REPLACE(SPACE(10-Len(@Variable)),' ', '0'))

You can adapt this to your stored procedure or whatever

 

[tlbroadbent]

Use the Replicate function.

'ABC' + REPLICATE('0',10-LEN(@variable)) + @variable
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.