Concatenate Column data without using a cursor

Hi Everybody ,
I have a table
DECLARE @ConcatStr varchar(Max)
DECLARE @MyTable TABLE
(
Id int,
Property varchar(50),
Value DECIMAL(20,2)
)
INSERT INTO @MyTable
SELECT 1,p1,2
UNION ALL
SELECT 2,p2,4
UNION ALL
SELECT 3,p3,5
I wonna get in @ConcatStr=[p1],[p2],[p3],...,[pn]
without using a cursor
Any Ideas.Thanks in advance.

If you had done some searching on concatenation, you would have found plenty of code examples here.
SET @ConcatStr = ''
SELECT @ConcatStr = @ConcatStr + CASE WHEN LEN(@ConcatStr) = 0 THEN '' ELSE "," END
+ @MyTable.Property
FROM @MyTable
ORDER BY @MyTable.Property
SELECT @ConcatStr

DECLARE @Var VARCHAR(8000)
SET @Var = ''
SELECT @Var = @Var + [Property] + ',' FROM @MyTable
SELECT @Var

I have tested your suggestions.
No one gives the result.it gives @ConcatStr=NULL
Could u test please.I am surprised

Then the Property column is nullable, and contains null values on certain rows.
To skip those rows, add a WHERE clause.
To include blanks in the comma-separated list, use:
SELECT @ConcatStr = @ConcatStr + CASE WHEN LEN(@ConcatStr) = 0 THEN '' ELSE "," END
+ IS_NULL(@MyTable.Property, ' ')
FROM @MyTable
ORDER BY @MyTable.Property

DECLARE @ConcatStr varchar(Max)
DECLARE @MyTable TABLE (
Id int,
[Property] varchar(50),
[Value] DECIMAL(20,2)
)
INSERT INTO @MyTable
SELECT 1,'p1',2
UNION ALL
SELECT 2,'p2',4
UNION ALL
SELECT 3,'p3',5

SELECT @ConcatStr = CASE WHEN @ConcatStr IS NULL THEN [Property] ELSE @ConcatStr + ',' + [Property] END
FROM @MyTable
WHERE [Property] IS NOT NULL
SELECT @ConcatStr

Hey Amourg
look at this query. hope u want exactly this
DECLARE @MyTable TABLE (
Id int,
[Property] varchar(50),
[Value] DECIMAL(20,2)
)
INSERT INTO @MyTable
SELECT 1,'p1',2
UNION ALL
SELECT 2,'p2',4
UNION ALL
SELECT 3,'p3',5
declare @var varchar(3000)
set @var = ''
SELECT @Var = @Var + COALESCE (Property, '') + ',' from @MyTable
select @var