Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ALLTRIM in a sql expression of cursoradapter
Message
 
 
À
28/03/2010 10:44:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01457654
Message ID:
01457667
Vues:
32
>>>>I'm assuming that '%' is included into Vp_in already, because otherwise I don't see a reason for using LIKE and not = at all.
>>>
>>>In that case, there's no need to trim, is there ?
>>
>>No need to trim, you're right. I'm wondering why Bernhart insists on trimming.
>
>
>Maybe the %'s aren't in after all

May be. I would use = when we want an exact match and LIKE only for partial matches. It is also clearer from the maintenance point of view.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform