Got it, this works:

declare @i char(1)
declare @sql nvarchar(4000)
set @i='a'
SET @sql = 'select *,''''+@i+'''' from some_tbl'
exec sp_executesql @sql

@i is a value fetched from a different table by cursor

thnx anyway

I know, but that's not it, it's complaining about the value of

the variable as an unknown column.

It needs quotes or smthng.

Invalid column name 'a'.

I know, but something's still not right with the regex, it drops some records, which are clearly rtf text

hey,

thanx, but your regex is dropping all spaces in the text

I wrote a small dll, which takes a string runs it through the clipboard and spits it out. Then I created a extended proc tied to the dll and now...

Thank you, well, 'do it in SQL Server' meant a call from a stored proc.

I'm using this:

function dbo.st_RTF2TXT(@in varchar(8000)) RETURNS  varchar(8000) AS

BEGIN

DECLARE @object int

DECLARE @hr int

DECLARE @out varchar(8000)

EXEC @hr...

ok steve, we know...great info...;-)

actually everywhere, tons of oracle, banks mostly

yeah, left join the tables, and handle the nulls, ok, I see...well, everyone obviously sees...

hey, are you in tokyo ? lived there for awhile.

this should print the tree path :

create  procedure ref_id (@id int)

as

begin

 declare @ref_id int,

 select @ref_id = parent_id

 from _table_

 where child_id = @id

 while @ref_id in (select child_id from _table_)

  begin 

   set @id = @ref_id

   select @ref_id = parent_id...

thank you einstein...

I'm using your kind of example daily. I'm talking about code modifications.

You can try something like:

declare @queryString varchar(1000),

           @result int

set @queryString='create table r (result int) insert into r SELECT MAX(PERIOD) FROM dbo.Table1'

exec (@queryString)

select @result = result from r

drop table r

select  @result

peter

Sounds interesting, remote short term is fine.

I think I can help you there.

deepforest3345*at*hotmail.com