Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALLTRIM in a sql expression of cursoradapter
Message
 
 
To
28/03/2010 10:44:05
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01457654
Message ID:
01457667
Views:
31
>>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform