Can SQL search 3 tables for string?

[spdolan]

Hi folks.

I built a Sprint DB Database for my Ipaq, and the products table is 162000 records. The Ipaq won't ActiveSync tables more that 65.5k - Would it be possible to split this big table into three small ones, and have a form search all 3 for a value in a field?

Thanks

Sean

 

[PHV]

You may search an UNION query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886