1

Im running the query

  SELECT ART_REF FROM tablename WHERE SEMESTER_NUM=28

This query returns both positive negative a 0 results in the forms of 8, -2, 0.

how can i just return the values that are negative (-8)?

I've tired using the LIKE operator but with no success.

Cheers

SQB
  • 3,926
  • 2
  • 28
  • 49
rkyyk
  • 163
  • 2
  • 5
  • 13

1 Answers1

2

Try this way:

SELECT ART_REF 
FROM tablename 
WHERE SEMESTER_NUM=28 
AND ART_REF <0
Robert
  • 25,425
  • 8
  • 67
  • 81