thanks..this worked

thanks but this did not get 5%

Database 1 : Field SSN: Data Type: varchar: Sample 111223333

Database 2: Filed SSN_2 Date Type: varchar: Sample 111-22-3333

Is this what u r looking for ?

I want to filter based on not qual to

The equal to works the not equal to does not work

Thanks.It's basically a SSN number and in one table it is 111-11-1111 and in the other its 111111111. The query works if I use the equal to operator

Select Name, Key,...

Thanks for the input

Thanks for the input

How do I write a function to generate a random number

thanks for the contribution

Thanks for your input but I still believe we need the date but in a de-identifiable format

Ok the problem is that the research dept wants date information to do some kind of analysis work but without the actual date being shown in their analysis. So I...

Thanks. Any input as to how you did that ? Do you have a function/procedure ? The other concern is to scramble the date fields and then descramble it back....

Thanks but I am not sure if it work if I need multiple procedures for the same patient . For example a patient with the same DOB could have had...

Ok here is my situation. I work in a hospital where patient information like dob, date of admission, etc cannot be revealed due to HIPAA regulations. I work in the...