Assigning values to @variables

[seekwall]

I need to be able to assign either one of two values to a local variable in a stored proc depending on what is returned from a boolean type statement.

Basically if this statement returns true:

if exists
(
select sc.*
from syscolumns sc
inner join sysobjects so on sc.id = so.id
where upper(sc.name) = 'title'
and upper(so.name) = 'Master6'
)

I want to declare the variable as 'title'

otherwise I want to declare the variable as ' '


Is this possible?

 

[foxdev]

[tt]declare @nCount int, @cTitle varchar(20)

select @nCount = count(sc.id)
from syscolumns sc
inner join sysobjects so on sc.id = so.id
where upper(sc.name) = 'title'
and upper(so.name) = 'Master6'

if @nCount > 0
set @cTitle = 'Title'
else set @cTitle = ''
[/tt]
Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[seekwall]

cheers pal

just what I wanted