IS or =

[Bart Pietercil]

Hi list,

In this sp:

create or replace procedure spLogin(in vc_logon varchar,IN  
vc_password varchar)
begin
	set @user_id = select recid from tbl_users where user_logonname =  
vc_logon AND user_password = vc_password;

	IF @user_id IS NOT null
	or
	IF @user_id = NOT null
end

I am a bit confused because when I read the WIKI grammar rules I see

boolean_test
     :	boolean_primary [ IS [ NOT ] truth_value ]

which indicates that the first statement is correct but VStudio does  
not seem to recognise IS (in the autocomplete within SQLEditor)

TIA

Bart Pietercil

PS: sorry to come up with all those question but I need to get up to  
speed with stored procedures