Embarrassingly, I think I have found the problem. My text editor had wrap around at 120 chars meaning the -ofile.htm was on the next line. However it didnt display that...

Yes it does

AGGT_INRUNNING "SCORE" returns the following in QA

<FONT face=arial,helvetica size=2 color=blue>

<TABLE Border=1>

<CAPTION><H3>Tournament positions by relative Rank</H3></CAPTION>

<THEAD><TR>

<TH><FONT color=blue>Position</TH>

<TH><FONT color=blue>Player</TH>

<TH><FONT color=blue>Date</TH>

<TH><FONT color=blue>Aggt score</TH>

</FONT>

</TR></THEAD>

<TBODY>

                                                                                                                

----------------------------------------------------------------------------------------------------------------

<TR><TD>T82</TD><TD>Per-Ulrik Johansson </TD><TD>17 Nov 2003</TD><TD align=right>0</TD><TR>

(1 row(s)...

Unfortunately not. Any other suggestions

D:\readpga>c:\mssql7\binn\isql -Sclarcombe -dpga -Usa -P  -w256 -h-1 -Q"exec AGG

T_INRUNNING '''SCORE'''" -

isql: unknown option

usage: isql              [-U login id]          [-P password]

  [-S server]            [-H hostname]          [-E trusted connection]

 ...

OK Guys, I obviously havent explained this well enough

The piece of SQL is from a stored procedure. I run the stored procedure from a DOS command line using Isql and writing...

ok

I have

 SELECT

  "<TR><TD>"+

  PLAYER      + "</TD><TD>" +

  CONVERT(varchar(15),WEEK_DATE,106)   + "</TD><TD>" +

  CONVERT(varchar(6),AGGT_PUTT)   + "</TD><TD>" +

  CONVERT(varchar(6),AGGT_DRIVE)  + "</TD><TD>" +

  CONVERT(varchar(6),AGGT_SCORE)  + "</TD><TD>" +   

  CONVERT(varchar(6),AGGT_TOTAL)  + "</TD></TR>"   

 FROM

  pga..PLAYER_PROGRESS

 WHERE

  UNIQUEKEY = "HTANA"

I get

                                                                                                                                    

------------------------------------------------------------------------------------------------------------------------------------

<TR><TD>Hidemichi Tanaka </TD><TD>17 Nov 2003</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR>

 

How do I get rid of the ----------------------------------------------------------------------------------------

Thanks

 

Thanks. Just what I needed

OK, how do I do a computed column