Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys, i want to know, why this become wrong?
thanks
Your expression will be failing because you can't define a set using "like". Instead you would have to use the advanced search syntax in a set modifier, so something like:
[Invoice No] = {"*BS*"}, // to replace the [Invoice No] like {'BS'},
Your expression will be failing because you can't define a set using "like". Instead you would have to use the advanced search syntax in a set modifier, so something like:
[Invoice No] = {"*BS*"}, // to replace the [Invoice No] like {'BS'},
what is * in ' ', is that similiar with like or containing ?
It's a wildcard basically, so with the double quotes it is effectively creating a search for a list of values that match BS with a wildcard either side. If your string is always going to start with BS you might just have "BS*" instead.