Querying on a small string variable

Sterling Ferguson-II (1.6k●8●273●265) | 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.9k●7●14) | 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

Comments

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

Most liked answers ↑|Newest answers|Oldest answers

0	permanent link Abhinav Mishra (144●30●39) \| answered Jan 09 '15, 4:59 a.m. Hi Sterling, https://jazz.net/library/article/1007 Please go through the above article.Hope this will answer your query!! Thanks

It's all about the answers!

Related questions

Querying on a small string variable

Accepted answer

One other answer

Your answer