Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What am I doing wrong with this query
Message
From
27/02/2007 21:39:34
Rajani Puvvula
Hamilton, New Zealand
 
 
To
27/02/2007 18:56:06
Simplicio Jison Jr
Davao, Philippines
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: What am I doing wrong with this query
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01199358
Message ID:
01199409
Views:
18
Simplicio
you are right . i dont have nulls but have some blanks that causing this issue.
i changed to following and it worked beautifully
SELECT * FROM it WHERE
(!EMPTY(code) AND INLIST(ALLTRIM(code),'PT01','PT02','PT03','PT04')) OR
(!EMPTY(usercode) AND INLIST(ALLTRIM(usercode),'PT01','PT02','PT03','PT04'))

Thanks for ur help
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform