InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 22:50:29 GMT20http://www.sqlservercentral.com/Forums/Topic444012-65-1.aspxYeah, you are right, thanks :-)Wed, 18 Jul 2012 04:52:46 GMTdimitris.staikoshttp://www.sqlservercentral.com/Forums/Topic444012-65-1.aspx[quote][b]dimitris.staikos (7/8/2012)[/b][hr]The '*' is killing you. Use '%' instead.[/quote]Keep in mind that this isn't standard T-SQL. It's Full Text Search.Sun, 08 Jul 2012 12:27:16 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic444012-65-1.aspxThe '*' is killing you. Use '%' instead.If you want to search for text that for example contains % or other special characters you have to escape them.See the example below:SELECT * FROM(SELECT UserName + '&%' + Email AS A FROM Employees) GWHERE G.A LIKE '%s&!%x%' ESCAPE '!'I am concatenating two fields adding &% in between. No escaping needed there.And I want to look for any record that has the literal pattern 's&%x' inside itSo in the LIKE however, I start with an '%s (the equivalent of *), follow with an 's', follow with an '&' (no escaping needed) and then I escape the '%' using any character I like, so I chose '!'. Then follows 'x' and '%' for the rest of the string.Pretty straightforward right?CheersDimitrisSun, 08 Jul 2012 04:51:36 GMTdimitris.staikoshttp://www.sqlservercentral.com/Forums/Topic444012-65-1.aspxI have created a full text index on a column of a table. The issue is i need to search for AT&T.the query i use for search isSELECT * FROM TABLE_NAME WHERE CONTAINS(COLUMN_NAME, '"AT&T*"')It returns many records but doesn't return the records with AT&T in it. I guess '&' is killing it, but i have no idea how to escape it in case of full text index search.Any help will be deeply appreciated.Wed, 16 Jan 2008 14:22:52 GMTjeepee_in