At the minute I have code that allows the user to enter a reference number and it returns the record from the database matching that exact reference. But I would like it so that the user can enter only part of the reference and it will return all records that match and then the user can select the one they want. At the moment the web site is searching for the applications via an object data source and a stored procedure. Is it in here I need to change code and use a wildcard?

Has now been solved. Needed a wildcard in my SQL.

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.