Using GetProfileAttrAsList and the EXISTS Operator

The following table describes using the GetProfileAttrAsList outside and within the EXISTS operator.

If...	Then...
GetProfileAttrAsList is used outside the Exists operator.	It returns a comma-separated list of the MVG values. For example, if you are using a MVG called State that has the values CA, MA, GA, and CA is primary, then GetProfileAttrAsList (State) would return CA, MA, GA.
GetProfileAttrAsList is used within the EXISTS operator.	The function returns the value of the profile attributes in the format expected by the operator. For example, a typical usage of the EXISTS operator in this scenario is EXISTS ([Targeted States] = GetProfileAttrAsList(“State”)). This does a many-to-many match of the MVG Business Component Field Targeted State against the MVG profile attribute State.

If...

Then...

GetProfileAttrAsList is used outside the Exists operator.

It returns a comma-separated list of the MVG values.

For example, if you are using a MVG called State that has the values CA, MA, GA, and CA is primary, then GetProfileAttrAsList (State) would return CA, MA, GA.

GetProfileAttrAsList is used within the EXISTS operator.

The function returns the value of the profile attributes in the format expected by the operator.

For example, a typical usage of the EXISTS operator in this scenario is EXISTS ([Targeted States] = GetProfileAttrAsList(“State”)).

This does a many-to-many match of the MVG Business Component Field Targeted State against the MVG profile attribute State.