AW: AW: question about ALPHA and SOUNDEX function

2005-02-08 Thread Josu
Hallo, > -Ursprüngliche Nachricht- > Von: Josu [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 7. Februar 2005 16:52 > An: Zabach, Elke > Betreff: Re: AW: question about ALPHA and SOUNDEX function > > ALPHA issue: > > We have an unicode database but the colum

AW: question about ALPHA and SOUNDEX function

2005-02-07 Thread Zabach, Elke
Josu wrote: > > Hi, > > we are trying to implement a search method to grab the best results > and the most with a keyword given (keyword=a country, a province, a > city ) > > Until now we don't know how to do ALPHA queries, we try: > > select name,alpha(name) from countries where alpha(name

question about ALPHA and SOUNDEX function

2005-02-07 Thread Josu
Hi, we are trying to implement a search method to grab the best results and the most with a keyword given (keyword=a country, a province, a city ) Until now we don't know how to do ALPHA queries, we try: select name,alpha(name) from countries where alpha(name) like/= alpha(keyword) It resul