I take that back, it did work. I was putting my brackets in the wrong place.

Thanks!!!

That's what I tried originally.
I get the error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'f_item'.

The WHERE part of the SQL looks like this:
WHERE f_item LIKE '%ztb%'...

I have a SELECT statement THAT has several embedded SELECT statements. I want to search using LIKE on the result of the embedded SELECT (AS f_item, AS f_desc, AS r_item or AS r_desc).

The very confusing SELECT statement is as follows:

SELECT A.ID,A.date1,A. rmc_value,A.use rid,B.formula,B .finishedgood,B .rawmaterial,(S ELECT C.desc1 FROM C WHERE C.ID=B.finished good AND B.finishedgood> 0) AS f_item,(SELECT C.desc2 FROM...