Right. I couldn't see any advantage to indexing this field in the case you presented. My comment was just for future reference.
>First, thank you for your help.
>I will use nvarchar.
>But as far as indexing, if I do not plan to create an index tag for this field, do I understand that the limitation of not being able to index varchar(MAX) is irrelevant?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer