Yesterday I converted my site over to MS SQL and now I'm having an issue with part of my site. The search box is supposed to check for a part number the user types in, but it doesn't even come close anymore. In Access the column searched was a Number col. Now the column is a Float. The sql line is:
sql = select * FROM brandList WHERE partno LIKE '%%" & part_no &"'"
This was working in Access with out trouble.