Getting all of the records back

[EscapeUK]

Is there a 'like' function or anyway I can get back all my records (from a field of type int). I am using a rather complex select statement and sometimes I need to get back all the values but not all the time

 

[Ruairi]

I'm not sure i understand the question. If all you want is every value in the table for one field just use a select statement with no where clause.

select Int_Field from SomeTable

this would select every value from the Int_Field field in a table named SomeTable. Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontroltechnologies.com