Hi there. Ok, If I have a database with columns "FirstName" and "LastName" I could insert a row with no value for last name by calling INSERT INTO TableName (FirstName) VALUES ('Matt') Ok, easy. However, if I have a row already entered with a first and last name, how would I clear the first name to an empty value? By which I mean no value at all rather than an empty string. Can I do this with an UPDATE call? Is there a keyword to use such as "FirstName = NULL"? I could of course delete the row and add it again, but it seems like it should be easier than that.

I just don't understand where the Unicode byte pair (FF FE) comes from at the beginning of the file. The bytes for s and 4 certainly aren't similar to that... so what could possibly be confusing notepad? And how come if I type s42ext.dll (another of my company's dlls) it doesn't have that problem? Which character codes are the ones that cause notepad to barf? So strange...

s42itd.dll happens to be the name of one of my company's dlls. I was just trying to write it in a stupid text file. But of course, Microsoft just didn't want me to do that... "Just don't type that" will probably be the official work-around. :-)

Ok. So do this: Open Notepad Type "s42itd.dll" (without the quotes) Save and close Now, open the saved text file... I've done this on two different systems and all I get are 5 little empty boxes. Like it's trying to interperet the 10 characters I typed in as 5 bizarre unicode characters. What's the deal with that? Is notepad screwed up or am I???