Hi Wayne ---

You want the LIKE operator...the syntax is as follows:

SELECT * FROM table WHERE name LIKE "A_____" (All names 6 chars or less beginning with upper-case "A")
SELECT * FROM table WHERE name LIKE "A%" (All names any length beginning with upper-case "A")
SELECT * FROM table WHERE name LIKE "[a-gA-G]%" (Any name, any case starting with A through G)
SELECT * FROM table WHERE name LIKE "%[s-S]%" (Any name with an "s" in it, regardless of case).

>Attempting to retrieve data using $ (contained in) through ODBC to SQL Server. What's the correct syntax?
>
>Wayne