[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    MaxDB with Access Linked Tables
From:       Sim Zacks <sim () compulab ! co ! il>
Date:       2004-05-17 6:40:49
Message-ID: 278781838.20040517094006 () compulab ! co ! il
[Download RAW message or body]

I am trying to convert a project from Access to MaxDB backend with an
Access frontend.

I am having a slight problem with case sensitivity and the Like
predicate. Access won't pass the Upper function through and returns an
error that it is an undefined function. I tried using StrConv, the
Access function and that works for = but not for Like.

I want to do something like Select * from Names where Upper(lastname)
Like 'SMI%'

Does anyone have any thoughts?


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]