Member Avatar for priyam_maheshwa

Hi All,

I am developing a report generation web page in which i have a text box in which a user would enter a value and i have to extract similar data from my MS Access database.
I have tried using wild card % but it is giving an error.

SELECT *
FROM report
WHERE product_no like 't%';

I have checked my database it has "test" entry for field product_no.The data type of product_no is Text.

I would be grateful if anybody would help

Thanx

  • 2 Contributors
  • 1 Reply
  • 73 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by buddylee17
Member Avatar for buddylee17

Use the asterisk for the wildcard:

SELECT *
FROM report
WHERE product_no like 't*';
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.