Simple obfuscation using Exclusive-OR is fine for keeping the honest man honest...

But one of the first things hackers do on an SSN column is something like this...

1.  Take a...

SG,

We can help but we need to see some examples of the dates... as you can see from the posts above, there are a lot of possibilities...

Wow, Mark... that's quite the laudry list...

There are many solutions (and caveats as Tim pointed out) to your list of nice-to-haves... if you do a search on this site, I'm...

I don't have one but, rumor has it, that there are encryption tools on the Software Developers Kit disk that comes with SQL Server.  Without a doubt, someone will post...

Good point... but you have to know what the Recovery Model is set to.  If it's set to FULL, even SELECT INTO is logged.  Again, don't take my word for...

Never mind... here's the answer to that last question in my previous post...

http://support.microsoft.com/kb/153441/EN-US/

... and make sure that you read the part that says ...

NOTE: This problem does not...

I appologize if I repeat some of the previous posts but I think they might be worth repeating... and I believe John Marks referenced the same URL that I do...

I see why people come to the conclusion that you must use FLOAT as an input to functions... what people should say on funtions is that you must not use...

Excellent reference, GP... though I'm not sure what you meant by "you have to use Float if your application need math functions".  If you meant that you are inherently using...

Nope... massive deoderant failure on my part 

Sure, Mick... Sorry for the previous all too brief post...

First, let me tell you that the others are absolutely correct... SMALLDATETIME is rounded to the nearest minute and you should...

Sorry, Tim... poor choice of words on my part.

You are correct... cannot attach files... nicely formatted code.  Welcome aboard!

It's things like this that make me appreciate a good old fashioned IDENTITY column...

PW beat me to it... don't use float for anything, if you can help it.  It's one of those "approximation" data types that are based on binary math. 

Now, what...