Posted by SQL on 04/06/06 16:45

you need a BEGIN for every END
example

DECLARE @v BIT
SELECT @v = 1

IF @v = 1
BEGIN
select 'yes'
END
ELSE
BEGIN
select 'No'
END


Or without begin...end
IF @v = 1
select 'yes'
ELSE
select 'No'

Denis the SQL Menace
http://sqlservercode.blogspot.com/

[Back to original message]