0

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
2
Views
7 Years
Discussion Span
Last Post by hatrickwah
0

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.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.