Expression Web and SQL server 2

[lookup13]

I have designed a webpage for part info , a search and results
Linked to a Part database , but I want to search Data base for part numbers, I can search for exact using

Select * from Parts
Where Part_number like part_number

But I want to use wild cards *123* results 123456 Screw etc

Any Ideals , simple is best

Thank you in advance

 

[lookup13]

Yes and No ,Simple is best , when time is in short supply with a budget.Creating your own code would have less issues on certain apps, but on this simple Query , this will do.

On my search I want all data that is related to BC
BC154,BC155 an 123BC45,xcv12BC

Thanks again

 

[markros]

Change your command to

"SELECT * FROM [Parts] WHERE ([Part_number] Like @Part_number + '%')">

it should perform faster too.

 

[jbenson001]

Oh no problem. There is a Jason that posts often in that fourm. Maybe you thought I was him