Thanks for all your help and suggestions.

I ended up doing sort of a combo using substring and replace.

Job steps

1) select substring(vfdata, charindex('Email:',...

I'm either going to use a DTS or use our e-mailer program which creates spreadsheets based on a select statement.

I think, however, that i have found my answer.

The solution is...

Jeff:  Thanks for the response, but I think that I should clarify...

I want to export all the columns to an excell spreadsheet, but I want to 'hide' certain columns without...

Chip: That's just what I was beginning to realize!  Thanks for the suggestion.  I'll give it a go first thing tomorrow.

Regards,

Justyna

PW: Thank you for the response.  I'm not really sure what you mean though.  The above sql statement is part of a larger query involving cursors.  I do have the...

Thanks everyone for your help.

This is what I ended up doing...

rsROHSKEY.MoveFirst

Do While rsROHSKEY.EOF = False

    intROHS = InStr(UCase(rsVDL.Fields("DDDSC").Value), UCase(rsROHSKEY.Fields("ROHSKEY").Value))

    If intROHS > 0 Then

    intROHSLENGTH = Len(rsROHSKEY.Fields("ROHSKEY").Value)

    intROHSPOS = intROHS...

Jo:  No...upper lowercase doesn't matter.

JeffB:  Thanks for the suggestion.  I will give it a go and let you know what happens.

J

You know what PW, against all odds, I think I fixed it.

Select top 26 convert(varchar(11), WeekBeginning, 101) As WeekBeginning, Count(ssnpn)

From

(

  select CAST( DATEADD(day, (DATEPART(weekday, convert(char, mmdate, 112))-2)*-1, convert(char, mmdate, 112))...

Select top 26 convert(varchar(11), WeekBeginning, 101) As WeekBeginning, Count(ssnpn)

From

(

  select CAST( DATEADD(day, (DATEPART(weekday, convert(char, mmdate, 112))-2)*-1, convert(char, mmdate, 112)) As datetime)  as WeekBeginning,

    i.ssnpn

  from icg.dbo.mmarchive m

    left join...

I really appreciate the suggestion.  Alas, it is still not sorting correctly.  The 2006 data is at the bottom of the list still.  Hmmm.  Since I am a date conversion...

Fantabulous.  Now I just have to re-run this thing which will take about 10 years.

Keeping fingers crossed.

I would use a DTS and I would select the 'Send Mail' task if you have it available.  Then I would select the file to add as an attachment and...