you can try this format :

iif(isnull([Status]);"For All Jobs";iif([Status] = 1; "For All Closed Jobs";"For All Open Jobs"))

>> but does it when rendered in the browser via report manager.

Do you mean you are viewing this in internet explorer or netscape (as int html report).. if it's the...

SP3 is not out, so SP2.. but maybe he means SP3 for sqlserver but I'm pretty sure it's for win xp sp2

In answer to WSquared's comment, I'm using appname() on sqlserver in a trigger so any access options are off.

IN answer to Jonathan Stokes :

This is an ADP connected directly...

Thanx for the reminder... havn't coded anything in html for 8 months now :-(..

In answer of Al Matthews, if you try this you'll see the problem

Declare @Words varchar(255)

select @Words = 'This is a            test of the REPLACE FUNCTION'

select replace(@words,'  ', ' ')

gives : This is a      test of the REPLACE FUNCTION

instead of 'This...

can someone tell me why the double white spaces are removed from the posts??

It wouldn't work >>

declare @Words varchar(255)

select @Words = 'This is a test of the REPLACE FUNCTION'

select replace(@words,' ',...

How much faster is it than the other version?

Cleaner but slower doesn't do much for any of us.

Could you do some test and report back to the board??

if nothing has changed on the sqlserver side I'd check with the network guys... especially since it's something that has changed recently. But I can't help you any further...

what's the return type of DTSSource("Authorization#")??

if this is a string or a date you need to wrap it in quotation marks like this:

strSQL = "select AuthorizationNumber from REPRICE_AuthNumbers where...

Or on the same page as japie, you could make a search for the records... Something like : name like 'ab%' and state in (CA, FL) and.... (a little search...

case closed.. found out it's impossible to do something like that.. and for obvious reasons... I don't see how you could inner join on a ever changing recordset.

Thanx for the clarifications, that will solve my problems on the short term.. but I think I'm gonna go back to vb to do this one since I already have...

Actually I replace only the first occurance of the "create", so if I replace a comment instead of the script then I get an error that the object already exists.

You...

I forgot to tell that when I execute the printed statment I get nothing beyond Col01 printed (even id Col02 has text in it)... maybe that's another problem of its...