> I'm relatively new to SQL Server, and I was just wondering if anyone had a
> few site links which would show how to select with wildcards. (i.e.
> Selecting anti would return antibiotic, antipod, antioch, etc.)
SELECT * FROM table WHERE SUBSTRING(column, 1, 4) = 'anti'

SELECT * FROM table WHERE LEFT(column, 4) = 'anti'

SELECT * FROM table WHERE column LIKE 'anti%'
> Also, how do I take the results from two separate SELECT statements and
> merge them into a single recordset for processing?
Assuming the number of columns, and their data types, are identical:

SELECT column1, column2 FROM table1
UNION ALL
SELECT column1, column2 FROM table2

--
[url]www.aspfaq.com[/url]