Querying on a small string variable
RTC 405, 406
SQL Server
I have two fields that are type Small String and Editor Presentation String.
I want to run a query on one field using "exists"
The other query I want to run when field 2 is "blank"
The problem,
The first query and field return all records whether a value is there or not. The second query I can't figure how to search for a blank string.
Accepted answer
For the first query, you can use "is not". Then on Eclipse client check "Unassigned", on web client input a whitespace in the text box of the query condition.
For the second query, change "is not" to "is".
For the second query, change "is not" to "is".
One other answer
Hi Sterling,
https://jazz.net/library/article/1007
Please go through the above article.Hope this will answer your query!!
Thanks
https://jazz.net/library/article/1007
Please go through the above article.Hope this will answer your query!!
Thanks