asked on Replace NOT CaseSensitive
Hi,
Following code I use the replace a string is a field.
UPDATE Communication SET Documentname = REPLACE(Documentname, @vBasisMapDocumenten, '')
How can I make this Case Insensitive?
Following code I use the replace a string is a field.
UPDATE Communication SET Documentname = REPLACE(Documentname, @vBasisMapDocumenten, '')
How can I make this Case Insensitive?
Microsoft SQL Server 2008
Last Comment
Stef Merlijn
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
forgot the collate part:
UPDATE Communication SET Documentname = REPLACE(Documentname, @vBasisMapDocumenten, '') COLLATE SQL_Latin1_General_CP1_CI_
UPDATE Communication SET Documentname = REPLACE(Documentname, @vBasisMapDocumenten, '') COLLATE SQL_Latin1_General_CP1_CI_
ASKER
Thank you all.
Apparently the default for all created databases is Latin1_General_CI_AS which is case insensitive.
My filed had this set to the .
The additional info from the website was very helpfull.
Apparently the default for all created databases is Latin1_General_CI_AS which is case insensitive.
My filed had this set to the .
The additional info from the website was very helpfull.
could try this:
UPDATE Communication SET Documentname = REPLACE(Documentname, @vBasisMapDocumenten, '') SQL_Latin1_General_CP1_CI_