>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) + "%'"