How to Filter with "starts with" in Report Builder 3.0 Reporting Model Query Designer?
Posted on 2014-02-10
I have a filter for a text field. I want to filter out any items that starts with two letters "AB".
I'm working with a reporting model and the related query designer.
There is a "contains" option but I don't see a starts with or ends with option. Nor do I see an option to ender my own expression. I've tried contains with variations of the % and *, but neither worked. Any suggestions as to how to use a "starts with"/"ends with" type of filter with the query designer and a reporting mode? (not sql)