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
New Member Send Private Message
Posts: 0
New 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 Send Private Message
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
New Member Send Private Message
Posts: 0
New 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.