To 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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability