|
suona
Junior Member
Taiwan
121 Posts |
 Posted - 29 January 2004 : 22:07:59
|
installing Active Users MOD, and ......
if a column of my table, all contents are <NULL>.
How can I replace them with 1 ?
here's my SQL statement using in enterprise manager | SQL Pane
=================
UPDATE FORUM_MEMBERS
SET M_AUTHIDE = replace(M_AUTHIDE. '' , '1')
=================
with this type, I have replace other strings(not NUUL) succesfully,but this cannot work with NULL....
Is there any thing wrong ? |
I'm a amateur WWW site builder.
And Sorry for my poor english .....
 |
|
Topic Locked
