Hello All!

I believe that I am getting the syntax of a select statement wrong for
summarizing the backup information summary for all nodes that begin with
ln* from 11/12/2004 - 11/13/2004.  Here is what I have so far:

select entity as node_name, date(start_date) as date, cast(activity as
varchar(10)) as activity, time(start_time) as start, time(end_time) as end,
cast(bytes/1000000) as decimal(6,0)) as megabytes, cast(affected as
decimal(7,0)) as files successful from summary where date=11/12/2004 and
activity='BACKUP' and node_name='LN*' order by node_name

Would anyone happen to know what I am doing wrong?  I just can't seem to
get this query to work.  Thank you in advance!

********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************