Possible to use query is LIKE condition?

[ctakacs]

Hi Folks -



I have another thread going with an issue I am having and I'm trying out a few ideas I have.

I have a question with may be stupid, but possible to use a query is a LIKE condition?

For instance:

SELECT [Long_Code]
FROM [LT-SAP_CC_CMSO_Mapping]
WHERE [Long_Code] LIKE     '*(SELECT 
                                Switch(
                                    Len(Nz([Host Country Cost Center - ID], [Cost Center - ID])) - Len(Replace(Nz([Host Country Cost Center - ID], [Cost Center - ID]), "_", "")) > 0, Mid(Nz([Host Country Cost Center - ID], [Cost Center - ID]),InStrRev(Nz([Host Country Cost Center - ID], [Cost Center - ID]),"_")+1),
                                    Len(Nz([Host Country Cost Center - ID], [Cost Center - ID])) - Len(Replace(Nz([Host Country Cost Center - ID], [Cost Center - ID]), "-", "")) > 0, Mid(Nz([Host Country Cost Center - ID], [Cost Center - ID]),InStrRev(Nz([Host Country Cost Center - ID], [Cost Center - ID]),"-")+1)
                                ) FROM [LT-Global_Monthly_Headcount] 
                          )*'

Thanks!

[ranman256]

select * from table where [field] like "*ology"

[ctakacs]

Yes I know how to do that. I was trying to make it more dynamic though and use a query...not possible?

[orange]

Perhaps you should tell us in plain English WHAT you are trying to do and include an example showing
a) some sample data, and
b) the result that should be selected from that data by your Query.

As a side note, Access does not work well with field and object names with embedded spaces or special characters("-"...). Sooner or later you will experience some syntax issues.