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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Like Predicate Behavior in SQLBase 9

Status
Not open for further replies.
jkack53

jkack53

Technical User
Jun 10, 2005
1
US
My company has been running SQLBase since 1989. I have just upgraded a client to Version 9. Within our report writer we use Like predicates that often pass just the '%' percent sign for the search criteria. This of course has enabled the report to return all rows (including rows with a NULL value) In version 9 no rows are returned if the value of the column is NULL. Has anyone else observed this behavior and if so is there a fix for it?

TIA

Joe Kacmarynski
 
Status
Not open for further replies.

Similar threads

GuptaSteveL
  • Locked
  • Helpful tip
Gupta SQLBase Manuals
Replies
0
Views
153
GuptaSteveL
GuptaSteveL
jmillerflory
  • Locked
  • Question
SQLBase SYSADM password
Replies
5
Views
308
GuptaSteveL
GuptaSteveL
GuptaSteve
  • Locked
  • News
SQLBase v12.1 has been released !
Replies
0
Views
119
GuptaSteve
GuptaSteve
zqisme
  • Locked
  • Question
SQL Base Error Code 9268 for Gupta SQL 1
Replies
0
Views
280
zqisme
zqisme
ldoodle
  • Locked
  • Question
OR in StrIFF 1
Replies
2
Views
222
GuptaSteve
GuptaSteve

Part and Inventory Search

Sponsor

Back
Top