| Author: ashok 04 Jul 2009 | Member Level: Gold | Rating:  Points: 2 |
declare @field1 int, @field2 varchar(10)
set @field1=100
set @field2='temp'
select cast(@field1 as nvarchar)+cast(@field2 as nvarchar)
|
| Author: Krishnaveni 04 Jul 2009 | Member Level: Gold | Rating: Points: 2 |
select convert(varchar(50),@value) + convert(varchar(50),@value1)
|
| Author: Williams 05 Jul 2009 | Member Level: Gold | Rating: Points: 2 |
Hi
select cast([columnName1] as nvarchar)+cast([columnName2] as nvarchar) from [tableName]
|
| Author: ketha 06 Jul 2009 | Member Level: Silver | Rating: Points: 2 |
-- Concatenation With ','
select convert(varchar,ColumnName1)+','+convert(varchar,ColumnName2) From TableName
|
| Author: Devendra 06 Jul 2009 | Member Level: Gold | Rating: Points: 2 |
Use cast or convert
|