>You can use LIKE operator. It's optimizable as long as it doesn't start with wildcard character.

>WHERE trandate LIKE LEFT(myexceldate,10) + '%'
>

Great! I'll try that.

I was dreading having to go back to the client to have them resend the data with all info (which they may not even have). And I certainly modify structure and create another column and populate it with only left(10). We'll see how it goes and what speed do I get. I have to look for about 2000 transactions out of 41 mill.

Thanks.

PS: Would SQL syntax be:

... " AND trandate LIKE '" + LEFT(myexceldate,10) + "%'"