8 Replies Latest reply on Mar 12, 2013 8:02 AM by 947771

    Alternate for trim to convert spaces into null


      i do not want use ltrim or rtrim, becasue trim is also doing that job.

      if i have ' ' or null it shows 'a' else it show 'b' the type of empdepartemtn is any type which can hold charecter .

      select Case when trim(empdepartment) is null then 'a' else 'b' end from abc

      1) Is there any other way to get the above result?

      2) if the above col is lob then please send me solution sepratlly for lob.

      yours sincerely