Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inlist() woes
Message
 
To
04/03/2002 14:35:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00627988
Message ID:
00628001
Views:
16
Hi,

replace
Select * from dline where inlist(cde_tooth, '14', '1 ') 
with
Select * from dline where cde_tooth$'14'+'1'
inlist find a reference, but $ find extact in string. Contact with |, because if cde_tooth is 41, cde_tooth$'14'+'1' return .t. :D then:
Select * from dline where cde_tooth$'14'+"|"+'1'
[]s
Cordialmente,

Fabiano Costa
Previous
Reply
Map
View

Click here to load this message in the networking platform