Hi when I do a query, a table with 1 column comes up with no value. It not even a null. There is a column name and no value at all.

well em not sure abt ur question wat u exactly meant..

but why replace? u can probably do an update on that field, mildaina ra?

साथीलाई अङ्रेजीमा लेख्न सारो परे जस्तो छ| नेपालीमा खुलुस्त प्रश्न लेख्नुस्, म समाधान गरिदिन्छु तपाईंको समस्या?

Mr/Mrs. the_heerb,

it seem to me that your table's that column is not null, that mean you must have to put some data or char because of not null. you can do alter your that column too. if you want to insert null values.

thank you

Delta

There might be a empty string or even a special character that is not visible under ur current setings. Or whatever..........

Do Update

set column = null

where LEN(Ltrim(Rtrim(Column))) = 0