>Hi Gregory,
>
>Is the dollar sign needed or just '123' is enough? In our database, there is no such thing as Status = 123; there is Status = 1, Status = 2, etc., but not Status = 123. I thought that the dollar sign means that either 1 or 2 or 3. hhhmmmmm...
Exactly. The $ sign means, the string to the left is contained in (is a sbustring of) the string to the right. So,
"2" $ "123" matches the condition, wherease
"4" $ "123" does not. Only the values 1, 2, or 3 will be included with the filter expression.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)