Why (where) condition give me just empty column ?

Question

1.00/5 (1 vote)

See more:

From my Database (returnShipmentPos) should i get [ReferenceID] where = R-100235729-200'
but i dont get any result . i got just empty column ?!

I will be happy for an explanation

What I have tried:

select ReferenceID 

from returnShipmentPos

where ReferenceID = 'R-100235729-200'

Posted 2-Sep-19 5:43am

Abdalla Ben Omran

Updated 6-Sep-19 0:26am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2019-09-02T05:59:00

First off, why are you returning a ReferenceID that you already know? If you know it, there is little point in querying a DB to find it ... By all means, return a COUNT or similar, but fetching the value you are filtering by is somewhat silly.

Secondly, if it returns no columns that means there are no values that match in the table - you could be querying the wrong table, the wrong DB, or you could be looking for the wrong ID value. You will not get an "empty column" back from that query: if you are seeing empty columns, I'd look at the "raw data" the query returns and at what you are doign with it subsequent to the SQL call. Without your DB and the data it contains, we can't help you there - so start with SSMS and paste your query into a new query window.
If you get no rows, then change it to:

SQL

SELECT ReferenceID FROM returnShipmentPos WHERE ReferenceID LIKE '%R-100235729-200%'

And see if that changes the results. (Equality requires the data to match exactly; LIKE will match if the string is anywhere in the data.
If that doesn't help, remove the WHERE clause entirely, and see exactly what is returned.

Sorry - we can't do any of that for you!

dinesh42 · Answer 2 · 2019-09-06T00:27:00

The value that you used in your where condition might have some unicode characters which are not visible to naked eye but SQL server might have stored in the column. In that case if you copy the value and use it in your where condition SQL won't do exact comparison with UNICODE values. First try to identify if your referenceId column has any unicode characters in it.

Why (where) condition give me just empty column ?

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0