Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sage Data Query

Status
Not open for further replies.
StevenK

StevenK

Programmer
Jan 5, 2001
1,294
GB
We're seeing something obscure when we run SQL syntax against Sage data.
If we use : SELECT Stock_Code, Description FROM STOCK WHERE Stock_Code = 'StockCode1' then on occasions we do not see the required result. But if we use : SELECT Stock_Code, Description FROM STOCK WHERE Stock_Code LIKE 'StockCode1' (with no wildcard) it picks up the required record.
Why should this be the case ?
We've ruled out the fact that lower-case might be included so this isn't the issue.
Anyone know why we might be seeing such odd results as this ?
Thanks in advance
Steve
 
Status
Not open for further replies.

Similar threads

Baldur3635
  • Locked
  • Question
Changing a Query at Runtime
Replies
16
Views
867
Baldur3635
Baldur3635
ori_1
  • Locked
  • Question
Populate Excel file (like forms) with data from Delphi
Replies
0
Views
340
ori_1
ori_1
Peter Jackson
  • Locked
  • Question
Delphi Data Access Components Performance Improvement and RAD Studio 10.4.2 Sydney Support
Replies
0
Views
218
Peter Jackson
Peter Jackson
lenkost
  • Locked
  • Question
TImageContainer data structure
Replies
0
Views
118
lenkost
lenkost
MarkBKee
  • Locked
  • Question
Hi. Apologies for a vague query - Graphic issues when dragging folders in folder tree
Replies
0
Views
113
MarkBKee
MarkBKee

Part and Inventory Search

Sponsor

Back
Top