IS or =

[Ruslan Zasukhin]

On 20/9/07 3:23 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

> 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

NULLs always must be used with IS


IS was added into SQL because = cannot be used with NULLs


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]