Set rsInfo = Server.CreateObject("ADODB.Recordset")
Sql = " Select Distinct a.BrandId,b.BrandName from tblInfoLetter Where a.BrandId = b.BrandID Order by BrandName "
rsInfo.open Sql,Con ,3,1
if not rsInfo.Eof Then
While not rsInfo.Eof
Response.Write "
