Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using IF with LIKE
Message
From
14/10/2014 18:23:58
 
 
To
14/10/2014 17:47:48
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
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:
01609381
Views:
43
>Hello Lutz
>
>
>Thanks for your reply, but i think i discovered the problem:
>
>If I used a variable
>local myref as string
>myref = '0.600/'
>select bi
>go top
>scan
> if like ('myref*' , bi.ref)
>?bi.ref
>endif
>endscan

Have you tried something like this?
myref =  '0.600/'
select bi
go top
scan
    if like (m.myref+'*' , bi.ref)
        ?bi.ref
    endif
endscan
Previous
Reply
Map
View

Click here to load this message in the networking platform