This discussion is archived
8 Replies Latest reply: Mar 12, 2013 1:02 AM by 947771 RSS

Alternate for trim to convert spaces into null

947771 Newbie
Currently Being Moderated

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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points