accismStips
New Member
I'm using SQL Azure with asp script, and for the life of me, have had no luck trying to get this to work. The table I'm running a query on has many columns, but I want to query for distinct values on 2 columns (name and email), from there I want it to return the entire row's values. What my query looks like now:\[code\]SELECT DISTINCT quote_contact, quote_con_email FROM quote_headers WHERE quote_contact LIKE '"&query&"%'\[/code\]But I need it to return the whole row so I can retrieve other data points. Had I been smart a year ago, I would have created a separate table just for the contacts, but that's a year ago. And before I implemented LiveSearch features.