CODEWITHSUNDEEP
sql
user3420567
user3420567

Reputation: 1

Issue with Does not equal statement

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?

Upvotes: 0

Views: 32

Answers (1)

Pragnesh Khalas
Pragnesh Khalas

Reputation: 2898

Change this

WHERE TRUSPWK.SKN <>";

To

WHERE TRUSPWK.SKN <> '';

Upvotes: 1

Related Questions