Same thing happens, I lose my custom table and it displays every record. The SELECT is where I have it searching based on the user input, so unless I can figure out how to add that functionality in the SP itself I need it there for now.


>Ok, as long as you have it working...
>
>Although what if you select into TQuery rather than 'sql' and comment out the select following SQLEXEC statement?