What is the meaning of <> symbol in Stored Procedure?

Asked Jan 19 '18 at 09:02

Active Jan 19 '18 at 09:04

Viewed 1,233 times

I am new to SQL and Stored Procedures so I am not sure this is where I should ask this question.

Anyway, in my current project other developers are added many SP into the database. To study how to write SP, I go through some of them. And in one of them I saw a line like below

-- several lines of codes
AND pohpoid <> 0 
-- several lines of codes

Sp what is this <> code really mean in SQL Stored Procedure?

Note : My wild guess is less than or greater than.

asked Jan 19 '18 at 09:02

2

This means `IS NOT EQUAL`. – John Woo Jan 19 '18 at 09:03
3

It's the same as everywhere else - "not equals". Oddly, "less than or greater than" has the same meaning :-) – Sergey Kalinichenko Jan 19 '18 at 09:03
Or same as C's `!=`. – jarlh Jan 19 '18 at 09:04
Then why not just use `!=` – Jan 19 '18 at 09:05
Because != isn't valid to SQL. – L_Church Jan 19 '18 at 09:06
it means "not equal to" – Usman Jan 19 '18 at 09:15

What is the meaning of <> symbol in Stored Procedure?

0 Answers0