I've prototype exactly what you have suggested and it works to a point. In addition to these letters there are several flavors of financial statements that all have similar...

I still have not resolved my original issue so I tried to accomplish the same task in a different way...

Since I am unable to update via openquery I now am...

JV which one do you use again?

what's a few nano-seconds between friends?

This will return the date with the time seemingly stripped off (set to 00:00:00)

Select Convert(datetime, Convert(char, GetDate(),101)

returns 2003-07-30 00:00:00.000

hth

how about...

Group by Convert(char, your_date_field, 101)

quote:

---

I believe this is the correct syntax.

Delete Openquery(db2, 'select * from mytable')

If not then look at http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=sql&Query=openquery%2520delete&Queryc=openquery+delete&withinResults=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25 and see if anything helps...

Anyone else have any thoughts here? I've banked on getting this work and the bank now has insufficient funds. Thanks in advance.

Edited by - gsolomon on 05/02/2002 ...

negative...for example to select, my query looks like this...

Select * from Openquery(db2, 'select * from mytable')

to delete, I've tried,

Delete * from Openquery(db2, 'select * from mytable')

and

Delete from Openquery(db2, 'select...