en-UShe-IL
You are here:   Blog
Register   |  Login

Blog Archive:

Maximize
* Can be used in order to search for older blogs Entries

Search in blogs


Blog Categories:

Maximize
* Can be used in order to search for blogs Entries by Categories

Blog Tags:

Maximize
* Can be used in order to search for blogs by keywords

TNWikiSummit


Awared MVP 


 


Microsoft® Community Contributor 


Microsoft® Community Contributor


 Read first, before you you use the blog! Maximize

Recent Entries

Minimize
מאי8

Written by: ronen ariely
08/05/2020 23:29 RssIcon

Well, here is the code and answer is in the result

CREATE TABLE Test([Id] int IDENTITY(1,1) NOT NULL,
                    [FullName] nvarchar(128) NULL,
 
                    CONSTRAINT [PK_Test_Id] PRIMARY KEY CLUSTERED (Id ASC));
 
INSERT INTO Test (FullName) VALUES
(N'F''Sheree Jones II'                 ),
(N'Cybèle'                             ),
(N'T''Junior'                          ),
(N'Urane Of Watson Lake'               ),
(N'J''Sirène De Dan Jourdain'          ),
(N'Goodson des loups de l''antarctique'),
(N'F''Sheree Jones Of Dawson City'     ),
(N'Pénélope Of Watson Lake'            ),
(N'Liubov''s Siren'                    ),
(N'Siréna'                             );
GO
 
select * from Test WHERE upper(FullName) Like '%SIREN%'
select * from Test WHERE  upper(FullName) COLLATE Latin1_general_CI_AI Like '%SIREN%'  COLLATE Latin1_general_CI_AI

result: