DECLARE @VistaLimit VARCHAR(20)
DECLARE @Win7Limit VARCHAR(20)
DECLARE @VistaWin7Limit VARCHAR(20)
DECLARE @RelName VARCHAR(20)
SELECT @RelName = [Name] FROM Table name WHERE ReleaseNameID = 3956 ProductGroupID = 30
IF @RelName <=15.14
BEGIN
print 'here'
END
ELSE IF @RelName =15.15
BEGIN
print 'here1'
END
ELSE IF @RelName >=15.16
BEGIN
print 'here2'
END
ELSE
BEGIN
print'here3'
END
here my problem is How can i compare @Relname with given values .@RelName values are coming like 15.16,15.win7, 15.12win7,15.11win7....etc.. please help how first loop is executing when @Relname is 15.12win7
DECLARE @Win7Limit VARCHAR(20)
DECLARE @VistaWin7Limit VARCHAR(20)
DECLARE @RelName VARCHAR(20)
SELECT @RelName = [Name] FROM Table name WHERE ReleaseNameID = 3956 ProductGroupID = 30
IF @RelName <=15.14
BEGIN
print 'here'
END
ELSE IF @RelName =15.15
BEGIN
print 'here1'
END
ELSE IF @RelName >=15.16
BEGIN
print 'here2'
END
ELSE
BEGIN
print'here3'
END
here my problem is How can i compare @Relname with given values .@RelName values are coming like 15.16,15.win7, 15.12win7,15.11win7....etc.. please help how first loop is executing when @Relname is 15.12win7