Contractor UK Bulletin Board - View Single Post - SQL to restrict rows by first letter / number

lilelvis2000 · 10th July 2008, 15:27

How many bands are you tracking? 100K? 1M? wow!

Besides you could just make a function index in oracle, or calculated column in SQL server and index it.

10th July 2008, 15:27	#15
lilelvis2000 Contractor Among Contractors Join Date: Jul 2005 Location: the centre of the world - according to Jack Straw Posts: 1,590	How many bands are you tracking? 100K? 1M? wow! Besides you could just make a function index in oracle, or calculated column in SQL server and index it.