Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using IF with LIKE
Message
From
14/10/2014 15:51:36
 
 
To
14/10/2014 15:11:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01609335
Message ID:
01609354
Views:
69
Minor quibble...

s1=s2 && This is true
s2=s1 && This is false

>Nope. Can't do it LIKE is part of SQL.
>
>However, once you understand how VFP does string comparison, you may not need it.
>
>s1 = "Luis Santos"
>s2 = "Luis"
>
>? s1 = s2 * this is false
>? s2 = s1 * this is true
>? s1 == s2 * this is false
>? s2 = "" * true
>? s2 == "" * false
>
>VFP compares strings up to the length of the string on the right. == means exactly equals.
>
>>Hello comunity
>>
>>I need help about using na IF condition with LIKE
>>
>>for exemple on my code i have:
>>IF LIKE('0.600/*',bi.ref)
>> replace qtt with 1
>>ELSE
>>return
>>ENDIF
>>
>>Note the field bi.ref = '0.600/1182'
>>the problem is my IF with LIKE never work and i don´t know how to solve this problem.
>>
>>Many thanks,
>>Luis Santos
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform