enrique_aeo
asked on
collate
I have this query
select * from archivo1 a
inner join padron.dbo.padron_ruc_bdu b
on a.num_doc = substring (b.ruc,3,8) collate modern_spanish_ci_as
where substring(b.ruc,1,2)<>'20'
i do not understand the use of collate modern_spanish_ci_as
select * from archivo1 a
inner join padron.dbo.padron_ruc_bdu b
on a.num_doc = substring (b.ruc,3,8) collate modern_spanish_ci_as
where substring(b.ruc,1,2)<>'20'
i do not understand the use of collate modern_spanish_ci_as
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for your input