Compare letters, v-w, s-z...

Hello,
I have SQL2000.
If I search in a varchar after 'Eva', I get both 'Eva' and 'Ewa' (v-w), and
that is really great.
Is there a way to administrate this? Can I add more "compares", so if I
search for 'Has' I get 'Has' and 'Haz' (s-z)?
Regards,
/Mikael SörenssonThe reason is that you are using a collation where the letters W and V are
treated as the same letter. In Sweden, AFAIK, there is no W formally, hence
this treatment. You would have to find a collation which treats S and Z in a
similar way, but then the collation might not handle V and W anymore. There
is no setting except the collation setting, I'm afraid.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Mikael" <mikael@.DELETETHISslk.nu> wrote in message
news:%23W%23LUirqDHA.2000@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I have SQL2000.
> If I search in a varchar after 'Eva', I get both 'Eva' and 'Ewa' (v-w),
and
> that is really great.
> Is there a way to administrate this? Can I add more "compares", so if I
> search for 'Has' I get 'Has' and 'Haz' (s-z)?
> Regards,
> /Mikael Sörensson
>