Hi,

Stored procedure check null logic is not working in PowerServer (PB2021 beta version).

I have to replace check null logic with check blank space , any solution to fix it without changing stored procedure code ?

eg.1 

 INSERT INTO #decodes (Display, Data)
    SELECT RTRIM(col_value) + ' - ' + RTRIM(descr_long)
          ,RTRIM(col_value)
    FROM KL_CLIENT_PARMS.dbo.pMiscDecodes
    WHERE comp_nr = @default_comp_nr
    AND plan_nr = @plan_nr
    AND col_name = @field_source
    --AND RTRIM(LTRIM(col_value)) != NULL
    AND RTRIM(LTRIM(col_value)) != ''
    AND called_from = 'S'

eg.2

 -- IF rtrim(substring(@TRDA,52,1)) != NULL
    IF rtrim(substring(@TRDA,52,1)) != ''
             SELECT @DSHI = substring(@TRDA,52,1)