Creating a Table via SQL statements

[Mark]

I want to build a class with the following functions:
a. Creates a table (temporary) via SQL
b. Read through the table in the given an argument to find in the table

I like to see some sample code for both functions.

Thanks Mark