How to use concat method in sql server?

[vasavivenu]

How can i use concat method in sql server/sql express? Can you show a simple query example?

vasavivenu

[Rabbit]

In SQL Server, you just use the + operator for concatentation.

[vasavivenu]

thank you, but when i was try to con-cat of to integers,
it gives addtion of those values.how can i over come this?

thanks
vasavivenu

[gpl]

CAST them as strings (varchars) first
eg

select cast(number1 as varchar(25)) + cast(number2 as varchar(25))