Concatination

You mean you want to take 1000 rows of one int column ,and turn them into 1 row of 1 column where the value is the string concat of all rows?

1
2
3
...
998
999
1000

->

"1, 2, 3, ..., 998, 999, 1000"

-
It's hard. I'd just do it in the client side code

Either that or you mean:

SELECT 'B' + 123

I have tried that in my SQL Server 2005 but it generates error. That it cannot convert integer into string

erm.. more like that its trying to convert the 'B' into an int..

Try

select 'B' + CAST(123 AS VARCHAR)

Or use oracle. Its much less dumb with things like this.

Thanks it worked. In front of Oracle 9i. I consider SQL Server 2005 dull

OK now I want a slight change. My Query is like this.

SELECT 'B00' + CAST(B_Code AS VARCHAR) FROM Paramet

Where B_Code is a numeric

Now there is a slight problem. If the value of B_Code is in single digit then its OK but if its 2 digits lets say 17, then it will Display B0017 similarly if its 3 digits lets say 100, it will display B00100.

But I don't want it this way. I want it to be displayed in such a way that in first case it should display B017 and in 2nd case B100. How can I achieve this??

Thanks in Advance