I used following code to group data and insert into the Drop down box to search records via users. But im not
getting correct output. i guess because of special characters. i just wondering how to use search without deleting above
special characters. Any idea appreciate.
Drop down box - sql code
select [Company Name] From database1 GROUP BY [Company Name]
select [Company Name],Name,[Address 1],[Address 2],[City] From database1 WHERE [Company Name] IN(@CompanyName)