I'm trying to use the Auto Complete control to search through a column of data of "Lastname, Firstname".
If you type the Lastname followed by the comma, it resolves...
When you put the space in and start to type the first name, it goes blank like it can't find a match.
I'm not sure if this is a SQL thing or a K2 thing, but it's really annoying. Without having to re-format that column to remove the comma or something drastic like that, does anyone have any ideas on how to make the auto-complete control truly search for "Lastname, Firstname"?
Rob
