Thanks for all replies so far. The affected database is part of a database mirror and therefore in full recovery mode, also edition is standard, so no online rebuild for...

Hi Wendell

Thanks for your input, I'll clarify this, as this access db was not written by us, we just provide the infrastructure and the db server. I'll come back as...

It's ORed, I just verified from the application. It's solarwinds database, so unfortunately no, I cannot make any changes to the ERD. However I can make a stored proc, this...

Sure. Let's start with the query in the tblGroup table, called ContainerMemberDefinitions in my production system:

SELECT Expression

FROM [ContainerMemberDefinitions]

where ContainerID = 15

This gives me the following result

---------------------------

Nodes.Caption LIKE '%adsl%'

---------------------------

Nodes.CustomProperties.Comments...

exactly. I know how to do this in c# or other, but is it possible with tsql?

Thanks for reply, but this does not work. I was not clear, the where clause for tblNodes is already stored in tblGroups.expression

------------------------------------------

|Expression ...