How to write query for autocomplete suggestions
Presently i am using this query
select top 10 productname from prpducts where productname like 'go%'
result:
Gold & Ivory Coloured Regal Bedspread
Gold & Ivory Duvet Set
Gold & Ivory Quilted Bedspread
Gold / Nickel Finished Christmas Bells
Gold / Silver Melting Furnace
Gold /Platinum Crucibles and Moulds for X-ray Fluorescence Analysis
Gold and Carat Balances with Electronic Anti-theft Code
Gold and Diamond Finger Rings
Gold And Diamond Jewellery
Gold And Red Colored Hindu Wedding Cards
But problem is ,i want different results
like
gold................
goat........
godrej.......
goods........
gown........
go nogo.........
gong.........
govia.........
god ganes........
golf...........
etc
so,please tell me the query format