Thanks Simon.

What if I have a SerialID column contain in the Indexed view and plan to join that view to other tables using said SerialID column.

Does it make sense to...

Sorry Simon, to clarify:

I want to index the Account ID field for joins - not members of the where clause necerssarily. This way - I can join the accounts...

Thanks Simon-

I guess the 8000 byte limit is the varchar max length ?? Anyway - yes - my function is basic and lacks alot but works for the moment....

Thx Dave-

I use this UDF which is called from another SP. My website code calls a SP with a list of Client ID's to view. Then - the...

My original AList which is comman delimited CAN be modified. It's just a string that I create in code - could be in any format but it is a...