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.


Ignore, I found the answer on MSDN. Floats are no good for SQL statements involving LIKE or = . In this case, I changed the type over to Numeric and now it works fine.