It's all about the answers!

Ask a question

Querying on a small string variable

Sterling Ferguson-II (1.6k9284269) | asked Jan 07 '15, 3:26 p.m.
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

permanent link
Lily Wang (4.9k714) | answered Jan 09 '15, 1:35 a.m.
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".
Sterling Ferguson-II selected this answer as the correct answer

Sterling Ferguson-II commented Jan 12 '15, 8:53 a.m.

Thanks about the Eclipse client. It's weird that this is only available here. When I put a whitespace in the web client, after refresh, the Condition disappears.

One other answer

permanent link
Abhinav Mishra (1443139) | answered Jan 09 '15, 4:59 a.m.
Hi Sterling,

Please go through the above article.Hope this will answer your query!!


Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.