SQL server help please

Archived from the original Sajha.com — preserved as posted, replies can no longer be added here.
Start a New Discussion
Archived Post

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. How to i insert NULL if on that field. I cant do replace (column_name, NULL, 'value') because it is not NULL, there is nothing there ! any help is appreciated/

the_hareeb · Apr 29, 2010 9:51 AM · 2,024 views

4 Replies

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?

perfectionist · Apr 29, 2010 9:56 AM

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

newlynew · Apr 29, 2010 10:05 AM

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

DeltaGamma · Apr 29, 2010 10:15 AM

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

STUPIDA · Apr 29, 2010 10:22 AM

This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.

Start a New Discussion

You might be interested in...

Latest Community News View all
Page 1 of 9
Recent Classifieds View all
Page 1 of 28
Upcoming Events View all
Page 1 of 2
Service Providers View all
Page 1 of 21