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

    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