select *from table where colum like %ir% 

as a result of this query ====> 

"öz"
"cesur"

How can I cope with this problem?


#region usings

using System;
using System.Data.SQLite;

#endregion

#if MONO
using Mono.Data.Sqlite;
#else

#endif

namespace ASC.Data.SQLite
{
#if MONO
    [SqliteFunction(Name = "upper", Arguments = 1, FuncType =
FunctionType.Scalar)]
#else
    [SQLiteFunction(Name = "upper", Arguments = 1, FuncType =
FunctionType.Scalar)]
#endif
    public class UpperFunction :
#if MONO
        SqliteFunction
#else
        SQLiteFunction
#endif
    {
        public override object Invoke(object[] args)
        {
            if (args.Length == 0 || args[0] == null) return null;
            if (args[0] == DBNull.Value) return DBNull.Value;
            return ((string) args[0]).ToUpper();
        }
    }
}



these codes do not work.

What should I expect your help.


--
View this message in context: 
http://mono-for-android.1047100.n5.nabble.com/Sqlite-like-i-u-I-problem-tp5667630p5667630.html
Sent from the Mono for Android mailing list archive at Nabble.com.
_______________________________________________
Monodroid mailing list
[email protected]

UNSUBSCRIBE INFORMATION:
http://lists.ximian.com/mailman/listinfo/monodroid

Reply via email to