There should'nt be any difference. Check this by running the SQL from the command window. Are you pulling from the open view or from the Oracle table?
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California