OrderBy with Wildcards

[red2002yzfr1]

I am trying to get the OrderBy to recognize wildcards (or to that effect). A scenario would be I would have more than one name in a field, EX: Name2, 4, 6. How do I use wildcards in the OrderBy and they are recognized.

ORDER BY (Table.Field)="Name1", (Table.Field)="Name2", (Table.Field)="Name3", (Table.Field)="Name4", (Table.Field)="Name5", (Table.Field)="Name6", (Table.Field)="Name7", (Table.Field)="Name8";

 

[ST4RCUTTER]

red2002yzfr1,

Just for my clarification here. You are currently storing multiple name values in one field? These are then separated by commas or some other punctuation? In essence this is one big text string with multiple values?

 

[red2002yzfr1]

That would be correct. I know its not a good thing, but for right now, it is what I am working with. I plan to change it to be separate fields. EX: name1, name3, name5