Posted by jim_geissman on 07/28/06 17:03

Can I create an index on a variation of a column that isn't actually in
the table?

I have a ParcelNumber column, with values like

123 AB-670
12345ABC 000-00-040
12-345-67
AP34567890

The blanks and non-alphanumeric characters cause problems with users,
because sometimes they're there, and sometimes they aren't. So I would
like to create an index based on this column, with the non-alphanumeric
characters squeezed out. Of course I can add such a column to the
table and index it, but I'm wondering if it can be done without
actually adding the column.

Thanks,
Jim

• Next in forum: AFTER INSERT trigger not firing in SQL 2005
• Prev in forum: Re: Ordering results by order of the "IN' clause
• Thread view: Index Computed Column?

[Reply to this message]