Who's On?

	Membership:
	Latest: Jeffin Joy
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 4988

	People Online:
	Visitors: 37
	Members: 0
	Total: 37

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

SQL server command to remove 2 from column

2 Replies

0 Subscribed to this topic

19 Subscribed to this forum

Sort:

Author

Messages

bgodwin

New Member

Posts: 0

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

4/23/2007 9:20 PM

How about update lawson.PRMONITOR set LP140_RUN_FLG = ' ' to set it to space?

bgodwin

New Member

Posts: 0

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.