🚀 go-pugleaf

>SELECT * FROM alias WHERE UPPER(field) LIKE UPPER("searchstring")
>
>This works fine, when field is a String-Field, but an error occurs, when
>field is a memo. How can I turn memos into upper-case ?

Ya can't do using SQL. However, it can easily be done with a canGetRow event
handler, if you're using VdB7, or SET FILTER if you're using VdB5:

 // VdB7
 rowsetObj.cangetRow = ;
 {||upper(this.parent.fields["MEMOFLD"].value) = "SEARCH STRING"}

 * VdB5
 set filter to MEMOFLD = "SEARCH STRING"
__
Bowen Moursund (TeamB)
bowenNOSPAM@nerds.com
http://lonestar.texas.net/~moursund/
Try this help resource:
http://www.dejanews.com/home_ps.shtml