Alternate for trim to convert spaces into null
947771Mar 4 2013 — edited Mar 12 2013Hi,
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