Issue with Does not equal statement

Question

I keep getting "syntax error in query expression" messages. I have a table full of values where ItemNbr is made up of cells with #s/values and blank(no value) cells. I want the statement to return results where item number will not be a blank.

My statement is:

SELECT DISTINCT TRUSPWK.SKN AS ItemNbr, TRUSPWK.SKNDESC AS ItemDesc1, TRUSPWK.EANUPC AS UPC, TRUSPWK.VNDRNAME AS VendName, TRUSPWK.VNDRNO AS VendStkNbr
FROM TRUSPWK
WHERE TRUSPWK.SKN <>";

The problem I'm noticing is the where statement: TRUSPWK.SKN <>"; Are the <> & " signs being misappropriately used?

Notice, that empty string and null value are quite different things. — Hamlet Hakobyan
– Hamlet Hakobyan, Commented Mar 14, 2014 at 15:53
Are you sure it is blank? Blank must be inserted, instead of NULL. — Alexander
– Alexander, Commented Mar 14, 2014 at 15:58

Pragnesh Khalas · Accepted Answer · 2014-03-14 15:54:36Z

1

Change this

WHERE TRUSPWK.SKN <>";

To

WHERE TRUSPWK.SKN <> '';

answered Mar 14, 2014 at 15:54

Pragnesh Khalas

2,8982 gold badges15 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Issue with Does not equal statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related