It's all about the answers!

Ask a question

Querying on a small string variable

Sterling Ferguson-II (1.6k8275268) | 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 (1443039) | 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.