Lynn,

Saw this while I was doing dishes... LOL It's mothers day...

Anyway, thanks for the reply. There is a very specific reason that fields are data type varchar(255). Actually, we keep them at 500 for all fields. The reason is that we are importing data from county databases that contain property information. The information, since people are the ones that manually key it in, is fraught with mistakes and very interesting entries.. Some examples would be Jan 32, 2069. That was fairly recent. If I shoved that date into a DateTime field, it would bounce back and yell at me... I'm married, so I get yelled at often enough 😀

Either way, for the purpose of just getting into the database from it's raw-flat file format, we constantly run into issues, so it's easier to keep it at varchar datatypes then what is correct.

I REALLY REALLY REALLY appreciate the help I get in this forum.. I really really do....

Thanks

and... if you're a mom.. Happy Mother's Day...(actually, I know a guy named Lynn... Hmmmm... )