IF Statement Syntax

• bmanning20

  SSC Veteran

  Points: 217

  More actions

  February 18, 2015 at 12:46 pm

  #301271

  I need help. There is a syntax problem with code below.

  If (select CPUTM from [dbo].[System_Management_Facility] where CPUTM > '0:00:55.38')

  THEN PRINT 'GOOD'

• LoudClear

  SSC Eights!

  Points: 999

  More actions

  February 18, 2015 at 12:57 pm

  #1778464

  Try this:

  If exists

  (

  select CPUTM

  from [dbo].[System_Management_Facility]

  where CPUTM > '0:00:55.38'

  ) PRINT 'GOOD'