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
Hi,

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

Legend

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