Like Operator

[menuch]

Can I use the Like command to compare a string of data to another database field?

Foe example I have a string of email addresses and I want to link it to my Microsoft exchange address book to see if an e-mail addrsss is in there?

Thanks!

Menuch
Report Designer

 

[synapsevampire]

What does this string of email addresses look like? There may be more efficient ways of doing this.

How does this string of email addresses get into the report?

Here's an example of the LIKE operator:

From CR Help:
Use the wildcard symbols ? and * to stand for variable characters. The ? stands for a single character. The * symbol stands for any number of characters, as in:

{table.field} like "c?ystalr*"

Wher the 2nd character is anything, and anything matching through and beyond the r character.

-k

-k