» How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?
How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?
|March 17, 2010
Posted by forumadmin
I’m looking to compare two varchars in SQL, one would be something like
Cafe and the other
Café is there a way in SQL that will allow the two values to be compared. For instance:
WHERE Name Like '%cafe%'
So if there is a venue with the name
Big Bobs Café Extraordinaire it would be included in the result set?
More Related Questions
- Japanese characters are not correctly in sql Problem:
I have to extract Data from a Japanese Navision which is saved on a SQL Server 2005 which saved all the data as varchar and in collation SQL_Latin1_General_CP1_CI_AI, Codepage […]
- How to append to a text field in t-sql SQL Server 2005 What is the best way to append to a text field using t-sql in Sql Server 2005?
With a varchar I would do this.
update tablename set fieldname = fieldname + 'appended string'
But this […]
- Doing a join across two databases with different collations on SQL Server and getting an error I know, I know with what I wrote in the question I shouldn't be surprised. But my situation is slowly working on an inherited POS system and my predecessor apparently wasn't aware of […]
- Get size of all tables in database I have inherited a fairly large SQL Server database. It seems to take up more space than I would expect, given the data it contains.
Is there an easy way to determine how much space on […]
- How can I do an UPDATE statement with JOIN in SQL? I need to update this table in MS SQL Server 2005 with data from its 'parent' table, see below:
- How do I create unique constraint that also allows nulls in sql server Adding a column to table, and I want a unique constraint, so the column will insert GUID's, but to allow for existing data before column was added, I need to allow for NULL's in the […]
- SQL Server – pull X random records per state I have a table with records for each zip code in the united states. For the purposes of displaying on a map, I need to select X random records per state. How would I go about doing […]
- How important is the order of columns in indexes? I've heard that you should put columns that will be the most selective at the beginning of the index declaration. Example:
CREATE NONCLUSTERED INDEX MyINDX on Table1
- How to SELECT * INTO [temp table] FROM [stored procedure] How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]?
Select all data from BusinessLine into tmpBusLine works fine.
- SQL update query using joins I have to update a field with a value which is returned by a join of 3 tables.
,im.sku as iSku
,gm.SKU as GSKU
,mm.ManufacturerId as ManuId