Member Avatar for hatrickwah

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.

Thanks

  • 1 Contributor
  • 1 Reply
  • 108 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by hatrickwah
Member Avatar for hatrickwah

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.