Null value in nonnullable field

mannoo19 · Post by **mannoo19** » Tue Aug 24, 2004 12:24 pm

Hi ,.,
Can someone help me how can I get rid of a space that is present in a char field..???
I used the conversion:
if trim(DSLink3.SWLNID) = '' then @NULL else trim(DSLink3.SWLNID)
But the problem is that the field is not nullable..so when it finds a '' it tries to put Null there and that is not accepted..
Can someone tell me what should be done??
thanks,

kcbland · Post by **kcbland** » Tue Aug 24, 2004 1:00 pm

If you don't like a space, your logic will put a NULL in its place. If it's a not-nullable column, then I suggest you use a different value to replace the blank or space.

ketfos · Post by **ketfos** » Tue Aug 24, 2004 2:51 pm

Hi,
You can use Ereplace function to get rid of it.

Ketfos