Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
BIRT 11SP3 like operator not returning all rows
Migrateduser
I have a simple report that is basically Select * from table where field like ?
A user noticed that the report wasn't returning all the rows that it should. I put the same query into Sql Server management studio and get the correct results. If I change like to equal sign it works correctly, returning the right number of rows.
A collegue mentioned chacking ANSI vs UNICode values and I'm exploring that.
Anyone run into this issue? If so, how is it solved.
Like gives the users flexibility to get all rows or just certain categories so we use it a lot. Thus, the need to solve this issue quickly.
TIA,
Dave Gress
Find more posts tagged with
Comments
There are no comments yet