Money Data Type

[PhilEvelyn]

Sadly I think the answer is "No", but if you don't ask, you don't get!

Once a NULL value in a money column has been given a value, is there ANY way of getting it to store a NULL value again?

And if not, can anyone tell me why I was so stupid as to use a money data type in the first place when I could just have converted the data in the app? (sorry, rhetorical question asked in frustration!).

Thanks

 

[sunila7]

Hi,

How r u trying to set the value to NULL.. If u r trying to do it from Query Analyzer then u can write a SQL stmt like this

Update tblname Set moneyfld = NULL where moneyfld is not NULL

or if u r doing from enterprise manager.
just press "ctrl + 0" in the field u want to set to zero

Sunil

 

[swampBoogie]

update t set moneyColumn = null where pkColumn = 4711

or am I missing something?

 

[PhilEvelyn]

Oops, sorry, doing this from inside the app, which is written in VB.