It all depends on how often you need to insert data between records.  If it is a rare occurance then there is little or no need to keep room available. ...

Try this as well.  It may run a little faster.  Use query analyzer "show execution plan" and test against your data to see which runs more efficiently.

SELECT consultantname 'Name...

We had a similar problem and solved it the way Vladan described using the LIKE comparitor in the WHERE clause.

Our biggest issue was maintaining the field when (in this example)...