DSXchange

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,

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.

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

Ketfos