NULL - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

NULL

Author

Topic

Saeed
Starting Member

39 Posts

Posted - 2002-08-12 : 18:35:41

@multimach varchar(2048)

MultiMach is passed on to a stored procedure as ''

however print '3' takes place..

if @MultiMach = NULL
begin
....
goto label
end
print '3'
label:

Ay idea why?

JustinBigelow
SQL Gigolo

1157 Posts

Posted - 2002-08-12 : 18:41:39

Try changing "if @MultiMach = NULL" to "if @MultiMach IS NULL"
An empty string does not equal NULL, NULL does not even equal NULL since both values are unknown. For the same reason make sure @MultiMatch is actually coming in as a NULL value and not an empty string.

hth,
Justin

Have you hugged your SQL Server today?

Saeed
Starting Member

39 Posts

Posted - 2002-08-12 : 23:57:28

Thanks Justin

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources