InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 18:50:25 GMT20http://www.sqlservercentral.com/Forums/Topic1076261-146-1.aspxTo do that in SQL you'd need a computed column on LEFT(other column), then you'd need to filter on that computed column. Not for performance, for when you really are matching on part of the column.Thu, 10 Mar 2011 10:31:13 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1076261-146-1.aspxwhen creating an index you can filter the index key to read only N number of characters in field e.g abcdefg and not abcdeftgghhjjjjjjjjjjjjjjjjjjjjjjjjjj. I understand that when the field is used in a query there is less of an overhead.Thu, 10 Mar 2011 09:40:54 GMTwhitlanderhttp://www.sqlservercentral.com/Forums/Topic1076261-146-1.aspxCould be computed columns, not sure. Could you explain more what the MySQL feature is?Thu, 10 Mar 2011 08:09:32 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1076261-146-1.aspxIn MySQL its possible to use index a prefix of a column to aid performance. is there an equivalent in SQL server?Thu, 10 Mar 2011 07:53:43 GMTwhitlander