Or you can use temp table Select * INTO #csrCustomer from Customer where state='CA' Select fname, lname from tempdb..#csrCustomer where fname like 'Mich%' and lname like 'Levy%' Group by fname, lname
Sorry, my fat fingers hit the send instead of the preview - another question - When does the temp table get destroyed? Or should I not concern myself with it?