Prev
Next
Forums Integration / Customization S3 Customization/Development

SQL server command to remove 2 from column

 2 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
bgodwin
Veteran Member
Posts: 143
Veteran Member
4/23/2007 9:16 PM
    I tried

    update lawson.PRMONITOR set LP140_RUN_FLG = null

    but it does not allow nulls...we need to get prmonitor reset to take the 2 out of the column

    any ideas?

    I was not about to do the pgmdef changes that gsc requested since I do not have c access.
    Ben Coonfield
    Veteran Member
    Posts: 146
    Veteran Member
    4/23/2007 9:20 PM
      How about update lawson.PRMONITOR set LP140_RUN_FLG = ' ' to set it to space?
      bgodwin
      Veteran Member
      Posts: 143
      Veteran Member
      4/24/2007 8:42 PM
        I suppose that I was nervous about putting a space in there...for the other columns that are showing as blank..there is not a space in there. Not sure how the system would react if it encounterd a space when it was not expecting it.