That did the trick!!!! Again, thanks for all your great help.

Mike

Thanks, it worked... How would I format the result to like like for example 20111219?

My select stmt is as follows:

Select SYSDATE

, LCO

, TMC

From lnkOracle_Table

Again, thanks for all your help...

Mike

I'm running the query from my ms sql server database where the linked server table is an Oracle table.