Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to find a shorter text on a longer column?
Message
De
12/12/2006 16:29:23
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01176930
Message ID:
01176975
Vues:
11
>You can use LIKE operator. It's optimizable as long as it doesn't start with wildcard character.
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform