InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 01:43:28 GMT20http://www.sqlservercentral.com/Forums/Topic1426826-1550-1.aspxThanks Chris..Fri, 08 Mar 2013 02:03:37 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1426826-1550-1.aspx[quote][b]Ratheesh.K.Nair (3/6/2013)[/b][hr]Thanks Chris for the reply.Problem i am facing is When selecting I am getting same data while using symbol Ｆ or F as search criteria both are giving the same result.[/quote][code="sql"]SELECT Descript, MyString, p2 = UNICODE(SUBSTRING(MyString,2,1)) FROM ( SELECT Descript = 'Normal Latin F', MyString = CAST(N'4F' AS NVARCHAR(2)) UNION ALL SELECT Descript = 'Wide Latin F', N'4Ｆ') d--WHERE MyString = '4F' -- need a width-sensitive collation hereWHERE MyString = N'4Ｆ' -- need a width-sensitive collation here[/code]Wed, 06 Mar 2013 07:41:10 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic1426826-1550-1.aspxWhat is the collation of the server/database/column?Wed, 06 Mar 2013 07:01:35 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1426826-1550-1.aspxThanks Chris for the reply.Problem i am facing is When selecting I am getting same data while using symbol Ｆ or F as search criteria both are giving the same result.Wed, 06 Mar 2013 06:43:44 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1426826-1550-1.aspxIt's difficult to find a question in your post. What are you observing now, and what would you like to see? Or are you looking for an explanation for an observation?Wed, 06 Mar 2013 06:36:35 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic1426826-1550-1.aspxcan anyone please help me on this??Wed, 06 Mar 2013 06:32:10 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1426826-1550-1.aspxHi Experts,In one of our database developers found an issue with data. The data is 4Ｆ which is returned correctly when using this value and the same is returned when given 4F. That is the symbol is replaced with 'F'. have to give N' (unicode) while searching with both the symbol and F. Any idea why this happens. The column data type is NVARCHAR.Thanks in AdvanceTue, 05 Mar 2013 07:30:56 GMTRatheesh.K.Nair