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,
Null value in nonnullable field
Moderators: chulett, rschirm, roy
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle