Kashida

[bmarzouk]

Hello,

How can I affect the Select Statement, so that it distinguishes between arabic words
with "Kashida" and those without "Kashida".

Thanks,
Belal Marzouk

[kchanning]

What databas eare you hitting against ... this will help a lot. Oracle has more robust functions for handling this then MS SQL-Server

[bmarzouk]

I am using Jet Database (Access)

[kchanning]

It is Sunday afternoon here ... May 27, 2001. I will take a look at it tonight and get back to you as soon as possible. I know how I would write it for Oracle ... I just have to try it for Access.


Cheers,
Kyle

[kchanning]

Hope this helps ... I created this procedure in Access '97 ... I think it does what you are asking for ...

SELECT *
FROM tblTest
WHERE (((tblTest.Value) Like "*Test*"));

This query returns every record where the word 'Test' appears in the field value, regardsless of its position. If this is not exactly what you need then please let me know what is missing.

Sorry for the late delay. I moved this past weekend so things have been a bit crazy lately.

If you need help on anything else feel free to email me directly.

Ciao!
kchanning