Checking positive number

[Pankaj Garg]

How should i check the positive value in sql server 2005 except the following? declare @f varchar(2000) set @f = '788' print charindex( '-' , @f )

[Rob Graham]

It would be nice if we could actually understand what you are trying to accomplish.

[Lost User]

Check if it's larger than 0 :)

DECLARE @f INT
SET @f = 788

IF @f > 0
BEGIN
PRINT 'It is positively positive!'
END
ELSE
BEGIN
PRINT 'That''s A negative there, Toto'
END

I are troll :)