Re: GLS
High,
as far as I know the collating order can be modified by setting the
LOCALE to ...@dict or some other but only for NCHAR od NVARCHAR-columns!.
But this doesn't have anny affect on your SELECT.
You have to say for example:
select ...
where column matches "[aA]*".
Best Regards
Dirk Reckeweg
Magnus Ljung wrote:
> I would like to change the collation order so that there is no
> difference between capitals and non-capitals. I would like to be able
> to ask SQL questions like:
> select name
> from t
> where name matches "a*"
> and get all names starting with a or A.>
> Does anyone know how this can be done, or where I can get some
> information about how to do it?
>
> Thanks,
> Magnus Ljung