Mensaje
De
12/12/2006 16:29:23
a
12/12/2006 13:23:06
General information
Foro:
Microsoft SQL Server
Category:
Sintáxis SQL
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
ID de la conversación:
01176930
ID del mensaje:
01176975
Views:
12
>You can use LIKE operator. It's optimizable as long as it doesn't start with wildcard character.
That worked, fast enough. Thx.
Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
WHERE trandate LIKE LEFT(myexceldate,10) + '%'
That worked, fast enough. Thx.
Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry